How to Use the Gauge Chart Template

In this blog post, I’m going to teach you how to use the Gauge Chart template.

Step 1: Download the Template

Go here and download the template.

Step 2: Update the Data Sources

Open the workbook. Note there are two data sources: gauge_placeholder and “Update this data”. Edit the “Update this data” data source.

In this data source, add a connection to your desired data source.

Edit the “Add to union. Remove Superstore” data object and add your selected data source to the existing union. Then remove the Orders table from the union.

Step 3: Update the Key Metric

In the “Update this data” data source, update the [Key Metric] calculated field (this is in the folder titled 00 – REPLACE THIS METRIC) with an aggregation of your desired target value. It needs to be an aggregation.

Step 4: Update the Target

Update your target value in the [Target] parameter.

Step 5: Customize All Other Parts

Use the parameters to make any additional adjustments.


The gauge chart template is a quick way to create a gauge chart without having to learn the details. If you are interested in learning more about how this chart was created, read the How to Build a Gauge Chart tutorial.

Accelerate and automate your data projects with the phData Toolkit

Data Coach is our premium analytics training program with one-on-one coaching from renowned experts.