Gauge Chart and Scoreboard chart with up/down tick

Sueann See
Sueann See Experian Super Contributor
edited December 2023 in Tips and tricks

Gauge Chart

A new chart type named Gauge chart has been added to the  Chart step. The Gauge chart is particularly useful for highlighting metrics that may have several threshold levels.

image.png image.png


Here is a sample Data Quality report where the Gauge chart is used to indicate the Average Row Pass Rate.

image.png


Scoreboard Chart with up/down tick

Notice how the Scoreboard chart is also used with emojis to show the up/down tick for the number of passing/failing rules. In order to achieve this, you will need to have a snapshot containing the number of passed and failed rules for the current and previous batch of data.

image.png

Within a Transformation step, define Functions and conditions as to when the up/down tick would apply. You can copy and paste the emoji you want to use instead of setting the condition as a text value. You will need to do this for every tick you want to display.

image.png

Example: Function for Passed Rules Trend

image.png

Each tick will need to be fed into a Chart step using the Scoreboard chart type.

image.png

This can then be combined with the Rules Count using a Report.

image.png

You can use multiple Report steps connected one after another and a combination of horizontal and vertical layouts to put together the final report.

Tagged: