Testing calculated fields

In CDP Data Visualization, you can easily test whether a newly calculated field works correctly or not.

  1. Click New Dashboard in the top left corner of this interface.
  2. In the new dashboard, click New Visual.
  3. Hover over the top right corner of the visual, and click the (pencil/edit) icon.
    Opening a visual in edit mode
  4. Select the Combo visual type, and populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.
    • Under Dimensions, select country, and place it on the Dimensions shelf.
    • Under Dimensions, select year, and place it on the Filters shelf. In the Filter for year modal window, under the Value tab, select the year 2010.
    • Under Dimensions, select un_region, and place it on the Filters shelf. In the Filter for un_region modal window, under the Value tab, select Europe.
    • Under Measures, select gdp_per_capita, and place it on the Bar Measure shelf.
    • Under Measures, select gdp, and place it on the Line Measure shelf.

      Click the (down arrow) on GDP field, and in the Field Properties, under Axis, select Secondary Axis.

    Applying Secondary Axis
  5. Click Refresh Visual.

As you can see, the two measurements appear on the graph, superimposed on each other: the original gdp_per_capita represented by the bars, and the calculated gdp, represented by the line.

Visual with original data fields and a calculated field