Page Comparison

A Summary chart displays just one number, either alone or with an icon, on a card. 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.

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.  You  The image below has some examples of the colored Summary charts you can add as widgets on your dashboard.

Image Added

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. Here are some examples of The image below shows how emojis add more of a visual impact when the Summary charts you can add as widgets on your dashboard.

Image Removed

display on dashboards.

Image Added

Example - Create a Summary chart (Smiley)

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.

1. Prepare the data in the grid:

   1. In Period mode, select the Customer dimension.

   2. Select Period > Current Month.

2. Click the Chart  button, then 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.

   Image RemovedImage Added

3. Configure the chart:

   1. Select Summary > Sum to display the sum of the customer sales in the month.

   2. Select Summary Type > Smiley.

   3. 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.

      Image RemovedImage Added

      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.

4. (Optional) Save the chart as a favorite or add it to a dashboard.

Example - Create a Summary chart (Emojis)

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 greenSummary chart, use an emoji for each value range, instead of a more traditional traffic light color scheme or smiley.

You can personalize Starting with the Summary chart by using an emoji of your choice for each value range, instead of a more traditional traffic light color scheme or smiley.

Image Removed

Emojis add more of a visual impact when the charts display on dashboards.

Image Removed

in the above example,

1. Select Summary Type > Emoji.

2. For each emoji (1 to 3):

   1. Select and insert an emoji:

      1. On Windows, use the Windows key + semi colon ( ; )

      2. On a Mac, use Control + Command + Space bar

   2. Enter the From and To

   and From

   1. value range into the

   color

   1. emoji boxes to set the conditional

   display. In the screenshot below, the user has chosen a party celebration face for the good news, a thinking face for the not-so-good news and and a frowning face for the bad news.Image Removed

   1. 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.

      Image Added

      The chart updates to emoji type and displays the applicable emoji.

      Image Added