Configure This View
Choose the Pyramid view and:
1. If needed, change the Select Dataset field to find the repeating items that contain the fields you want to chart. This must be the parent node to the fields you want to use and it must be a repeating node.
2. Drag the title of the column that contains the labels for each slice and drop this in the Label field.
Tip: For best results, limit the number of categories to 15 or less.
3. Drag title of the column that contains numeric data into the Value field.
4. Optionally, drag and drop a column with text values in the Tooltip field.
5. If the values of the Label field are not unique, change the Aggregation function from None to the function you want to use to calculate the value to use for each slice.
6. Click Next and set basic options for the chart in the Customize View step:
Set a
Caption or
Subcaption for the chart or gauge.
If needed, add a prefix or suffix for all numeric labels for this gauge or chart.
Common examples might be $ as the prefix or % as suffix.
8. Preview the chart at any time.
9. Once you are satisfied, save the view:
a. Click Finish.
b. Give the view a name, and optional description.
c. Click Save.