Pyramid Charts

Create a Pyramid Chart

A pyramid chart is a good choice for presenting related measures for one particular dimension, such as number of accounts and account values in a particular category.

For example, you're interested in looking at the overall value and number of accounts in countries where your company does business. A bar chart can show that data in order, but it's not necessarily a compelling or easy-to-read visualization. Changing it to a pyramid chart improves both overall appearance and readability.

1. In the lens, click and then select the Pyramid chart type.
2. In the Left Axis field, add the measure to include on the left side of the pyramid. For example, select Count of Rows.
3. In the Right Axis field, add the second measure. For example, select Sum of Amount.
4. In the Bars field, add a dimension to analyze the measures by, like Billing Country.
5. To sort the results by a measure, select the down arrow next to the measure and select the sort order.
   
6. To change the chart display, click and set the chart properties in the Formatting panel.
   For example, specify whether to show measure axes and titles.