You can create Histogram visuals in CDP Data Visualization. Histograms enable the quick visual analysis of numerical data distribution. They provide an estimate of the frequency distribution of a continuous quantitative variable, accomplished by splitting it into consecutive, non-overlapping intervals, referred to as "buckets".
To work around this limitation, first save the calculated metric as derived data, and then use this field as a measure in a histogram. See Derived data.
When you change the number of buckets (the default is 10), CDP Data Visualization determines the data range and splits it equally among the buckets, groups the metric into these buckets, and plots vertical bars to represent it.
Histograms support both normalized and cumulative forms, and may be used in a trellis formation.
The following steps demonstrate how to create a new histogram visual on the World Life Expectancy dataset.
For an overview of shelves that specify this visual, see Shelves for histograms.
Start a new visual based on the World Life Expectancy dataset.
For instructions, see Creating a visual.
In the VISUALS menu, select
The shelves of the visual changed. You can see: Measure (mandatory), X Trellis, Y Trellis, and Filters.
To show specific items, populate the shelves from the available fields
(X Trellis, Y Trellis) in the
Under Measures, select
populationand drag it to the Measures shelf.
Click REFRESH VISUAL.
The default histogram visual appears, dividing the data into 10 buckets. As you can see, most the data is in the first bucket, and this visual is not very enlightening.
On the Filters shelf, add several
Dimensions and Measures from
the DATA menu.
This enables you to dynamically control the data input and discover the data at a more granular level.
For example, from Dimensions, drag
yearto the Filters shelf and select the year 2010.
You can also add
un_regionto the Filters shelf and select Africa.
Click REFRESH VISUAL.
The shape of the diagram has changed. Hovering the mouse over the histogram shows the data ranges and frequency for each bucket of the histogram.
You can see that the filtering options significantly reduced result set.
Change the title to World Population - Histogram.
[Optional] You can also add a brief description of the visual as a subtitle below the title of the visualization.
- Click SAVE at the top left corner of the Dashboard Designer.