Jump to content
  • Animated Bubble Chart Mod for Spotfire®


    Version 1.1.0, released November 2021

    converted-file.thumb.png.99f6555ce401961f6317111e2832b88f.png

    button.png.cb6f738d5d8e212a80713f5362c4567c.png

    The animated bubble chart can be used to show how 2-4 measures changes over time. This method of visualizing changes over time was popularized by Hans Rosling in a famous TED talk from 2006 where he used it to show changes in global health and economics. Here's what that dataset looks like in Spotfire using the animated bubble chart mod.
    Clicking on the play button in the lower left hand corner below the visualization will show how Life Expectancy and Income per capita in different countries have changed over time.


    Data requirements

    Every mod handles missing, corrupted and/or inconsistent data in different ways. It is advised to always review how the data is visualized.

    The animated bubble chart can be used to visualize and animate any multi-variate dataset that contains snapshots of values taken at different timepoints. In order to make it work properly a data table with at least four columns is required:

    • One column should identify the bubbles, for example, names of countries, people or objects.
    • One column should contain a time point, for example years, or weeks.
    • Two columns should contain measures for the country, person or object taken at different times.


    Setting up the chart

    Let's say we have a grocery sales dataset that contains data about prices, costs and sales volume for different items:
     

    Type Item Year Price Cost Sales
    Fruit Apple 2000 5 3 10
    Fruit Apple 2001 6 12 8
    Fruit Apple 2002 7 13 9
    Fruit Apple 2003 10 5 11
    Fruit Banana 2000 7 1 16
    Fruit Banana 2001 9 5 20
    Fruit Banana 2002 10 8 25
    Fruit Banana 2003 11 9 10
    Fruit Pear 2000 4 1 8
    Fruit Pear 2001 5 5 5
    Fruit Pear 2002 3 8 15
    Fruit Pear 2003 2 20 25
    Veg. Cucumber 2000 1 4 10
    Veg. Cucumber 2001 9 2 8
    Veg. Cucumber 2002 10 13 9
    Veg. Cucumber 2003 5 5 11
    Veg. Squash 2000 3 8 16
    Veg. Squash 2001 2 2 20
    Veg. Squash 2002 3 2 25
    Veg. Squash 2003 10 8 10

     

    A basic animated bubble chart can be configured to show how prices and costs for different items have varied over time by creating an animated bubble chart with the following settings:

    • Y = Avg(Price)
    • X = Avg(Cost)
    • Animate By = Year
    • Marker By = Item

    Optionally you could also use color and size to show additional dimensions. E.g:

    • Color By = Type
    • Size By = Sales

    The end results will look something like this:
    basic_animated_bubble_chart.thumb.png.f53216a6f6d6ce896ce8124cf4c1be4b.png

    The chart shows one bubble for each item in your inventory list. Each bubble is positioned according to the price and cost in the year 2000. The size of the bubble represent the sales volume that year and the bubble is colored by item type. The current year is shown behind the visualization.

    When you click the the play button in the lower left hand corner the chart will cycle through the dataset and display data for each year. You can click pause to stop the animation at any time.


    Using the chart

    Scrubbing

    Click anywhere in the animation slider to skip to a particular time point. Drag the handle to manually move back and forth in time.

    Animation speed

    Click the speedometer to the right of the animation slider change the speed of the animation.

    Marking

    Clicking on a bubble will mark it in all timepoints. This makes it easy to follow one or more bubbles throughout the animation. Clicking in the empty space in between bubbles will clear the marking. You can mark several bubbles by Ctrl-clicking on them. Clicking and dragging allow you to select multiple bubbles. You can select all bubbles within a range of values by dragging along the y- or x-axis.

    Labels

    By default marked bubbles will be labeled. You can turn this behavior on or off by right-clicking in the y-axis area and checking or unchecking show labels for marked rows.

    Log scales

    Natural dataset often contains a lot of small values and a few larger values. If this is the case with data that you want to animate you may end up with a visualization that shows a lot of overlapping bubbles in the lower left hand corner of the visualization. One way to handle that is to use a log-scale on the x- or y-axis. You can turn on and off log-scales by right clicking in the x- or y-axis area and checking or unchecking the log-scale checkbox.



    Help and support

    This Mod for Spotfire® is not supported by Spotfire Support.
    In the event of issues or to suggest features and enhancements, submit an issue in the Mod's GitHub repository.

    For general questions about Mods, please post a question in the Forum for Extensions & Mods to make it visible and routed to the appropriate team(s) to respond.


    More information about Mods for Spotfire®


    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...