CDP Data Visualization enables you to create Sparklines visuals.
A sparklines chart shows the general shape of the variation in measurement (usually over time) in a simple, condensed, and memorable manner. Sparklines are small and succinct, and can be easily located with the text where they are discussed. You can contrast this with typical X/Y charts that are designed to show as much data as possible.
The following steps demonstrate how to create a new sparklines visual representation on
World Life Expectancy [data source
samples.world_life_expectancy]. For an overview of shelves that specify
this visual, see Shelves for sparklines.
- Start a new visual based on dataset
World Life Expectancy[data source
samples.world_life_expectancy]; see Creating a visual.
- In the visuals menu, find and click sparklines.
- Note that the shelves of the visual changed. They are now X,
Y, and Filters.
The mandatory shelves for sparklines visuals are X and Y, representing the X-axis and Y-axis.
Populate the shelves from the available fields (Dimensions,
Measures, and so on) in the Data menu.
Under Dimensions, select
yearand drag it over X shelf on the main part of the screen. Drop to add it to the shelf.
Under Measures, select
gdp_per_capitaand drag it over Y shelf on the main part of the screen. Drop to add it to the shelf.
- Under Dimensions, select
- On the Y shelf, on
gdp_per_capitafield, click the (down arrow) icon , select Aggregates, and then select Sum.
This is necessary because the sparklines chart type uses aggregated measurements.
- Note that the Y shelf now contains the modified field
- Click Refresh Visual.
The sparklines visual graph appears.
On the Filters shelf, add several
Dimensions and Measures from the
This enables you to dynamically control the data input, and discover the data at a more granular level.
For example, from Dimensions, drag
un_regiononto the Filters shelf.
- Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.
- Change the title to
World Population - Sparklines.
At the top left corner of the Visual Designer, click