Summary chart
- Helen Gosper
- Denise McGettigan
Available in a focused view (when you select and focus on items in a dimension), in all modes except for Transaction mode.
A Summary chart displays just one number, either alone or with an icon, on a card. This number can be the count, sum or average of the values selected.
This type of chart is suitable for displaying large numerical values, such as your total branch sales for the month, the value of goods in a warehouse or the profit for the quarter. You can save Summary charts as alerts that automatically appear on your home screen or dashboard when performance against a target reaches a certain point.
By default, a grey bar displays at the bottom of the card but you can apply conditional color formatting to use it as a clear visual indicator of performance. For example, you can set the bar to be red or yellow until a target is met or exceeded, at which point it will turn green. The image below has some examples of the colored Summary charts you can add as widgets on your dashboard.
You can also use summary icons, such as a smiley, emoji or arrow for additional visual appeal on your Summary charts. For example, arrows are useful to represent upwards or downwards trends when used with Variance or %Variance metrics. The image below shows how emojis add more of a visual impact when the Summary charts display on dashboards.
See Gauge and summary chart configuration for more information.
Example - Display the monthly sales total with a smiley icon
In a Sales database, create a Summary chart that shows monthly sales and apply conditional formatting so that as the monthly sales targets are met, the color on the chart changes from red, through to yellow and then to green.
Prepare the data in the grid:
In Period mode, select the Customer dimension.
Select Period > Current Month.
Click the Chart button in the top right toolbar above the grid.
Click the KPI chart category button on the left of the chart and select the Summary option.
The default Summary chart displays in grey color with the count of customers in the month. This does not meet the requirements, so you need to configure the chart.
Configure the chart:
Select Summary > Sum to display the sum of the customer sales in the month.
Select Summary Type > Smiley.
Enter the From and To value range into the color boxes to set the conditional formatting, so when sales are between 0 to $2m, the card displays in red, for sales $2m to $4m it is yellow, and for sales $4m to $6m it is red.
You can can see that so far this month, the target of $4m has not been met, so the yellow color displays. Later in the month, as the target is met, the color will change to green.
(Optional) Save the chart as a favorite or add it to a dashboard.
Example - Display the monthly sales total with an emoji icon
In a Summary chart, use an emoji for each value range, instead of a more traditional traffic light color scheme or smiley.
Windows 7 does not support this feature, as it has no built-in emoji picker.
Starting with the Summary chart in the above example,
Select Summary Type > Emoji.
For each emoji:
Select and insert an emoji. You can copy and paste an emoji from elsewhere or insert one using the built-in emoji picker, as follows:
On Windows, use the Windows key + semi colon ( ; )
On a Mac, use Control + Command + Space bar
Enter the From and To value range into the emoji boxes to set the conditional formatting, so when sales are between 0 to $2m, a frowning face displays, for sales $2m to $4m a thinking face displays, and for sales $4m to $6m a party celebration face displays.
The chart updates to emoji type and displays the applicable emoji.