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.

  1. Start a new visual based on the World Life Expectancy dataset.
    For instructions, see Creating a visual.
  2. In the VISUALS menu, select Histogram.
    The shelves of the visual changed. You can see: Measure (mandatory), X Trellis, Y Trellis, and Filters.
  3. To show specific items, populate the shelves from the available fields (X Trellis, Y Trellis) in the DATA menu.

    Under Measures, select population and drag it to the Measures shelf.


    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.

  5. 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 year to the Filters shelf and select the year 2010.

    You can also add un_region to the Filters shelf and select Africa.


    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.

  7. 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.
  8. Click SAVE at the top left corner of the Dashboard Designer.