Conditional Colored Number

Conditional colored number charts display a single metric and conditionally color the chart based on a target

Similar charts include:

• Bullet charts display data compared to a metric split out over different categories. Ranges and targets can be displayed overall or per category.
• Circular gauge charts compare a single metric to a target and can be conditionally colored.
• Speedometer charts compare a single metric to a target. Ranges in the speedometer can be set to indicate progress towards the target, and a marker indicates current progress.

How to create a Conditional Colored Number

The conditional colored number can be found underneath the Gauges section.

Data can be added to the two dataslots ‘Measure’ and ‘Target’.

Measure

Columns with data type ‘numeric’ or ‘hierarchy’ work best for this slot.

The data added to the measure slot will be aggregated and displayed in the middle of the number.

By default, the measure shows the sum of the values for a numeric column or the count rows for a hierarchy column. Different aggregations can be set to execute different calculations, e.g. the average.

Target

There are two ways to set your own target:

• Manual target - you can set a fixed target manually. Go to the chart settings, enable manual target toggle and add needed value there. Note: this setting becomes available as soon as a measure has been set up on the chart.

• Target slot - if you have a target column in your dataset you can add it to your chart directly.

Setting up the conditional Color and value displayed

Conditional colors the colors and ranges can be set in the chart settings.

You can change the ranges as desired, including how many ranges will be used, their values and their colors. Additionally, you can choose whether the color should be used as a background or for the number displayed.

You can also choose which value will be displayed on the chart: the aggregated value, the percentage of the target or the difference to the target.

Video Tutorial