Visualizer provides various configurable options for measures used in reports. One of these is the calculation of the measure across its attributes. By default, the calculation is the absolute value of the measure value.
Tip: In BQL, this is expressed as ABS([measure]), for example: ABS([OrderDate: Sum: Quantity])
In some cases you may rather use a different calculation in your chart. In addition to Absolute Value, you can apply:
Percentage Across: each column or row is a percentage of the total
You have access to the BQL in the Expression Editor to customize the calculation.
To use a Percentage Across calculation
- Add the measure
to Chart Builder and select it.
Visualizer displays the options available for the measure.
Tip: If you do not see the calculation, then the attribute may be missing. Add an attribute to the chart. - Click the
calculation option to see a list of possible calculations.
- Click Percentage
Across to see a list of relevant attributes.
- Click the attribute. Visualizer applies the calculation and:
- Updates the item in Chart Builder to show that it is a percentage across calculation.
- Adds the new measure to the Subject Area list of measures.
Tip: Click the plus sign (+) on a calculated measure to delete it. - Updates the measure axis to show percentages.
Examples of Percentage Calculation
Here is an example of a chart using percentage calculation. As usual, you can format the chart and tooltips to display the percentage values in different ways.
Here is the same information in table format, using a different decimal precision. Notice that the curly brackets { } indicate an expression is being used.
To see and edit a calculation for a custom expression in Expression Builder
- Select the custom measure in Chart Builder.
- Click Edit to open the Expression Builder.
Tip: If you do not see the Edit option, then the measure is not a custom expression.
The Expression Builder shows the BQL used for the calculation. - You can copy and/or edit the BQL. In this example the BQL is:
([Inventory_Date: Sum: Current_Inventory]/[Inventory_Date: Sum: Current_Inventory]{[Products.Total]}) * 100 - Click Done.