Gauge Chart and Scoreboard chart with up/down tick

Sueann See

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.

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

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.

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.

Example: Function for Passed Rules Trend

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

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

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