Turn Up the Dial on your Dashboard Design with New Gauge Charts

Turn Up the Dial on your Dashboard Design with New Gauge Charts

As analysts, unlocking hidden insights to convey meaningful information in easy-to-understand terms is imperative for stakeholders. Dashboard reporting is one of the most effective ways to showcase analytics insights, but without using efficient charts and graphs your dashboards may not be utilized to their best potential.

For example, your marketing team recently released a new campaign. Several questions can come up when viewing your dashboard:

  • Will this campaign hit its target of CTR’s?
  • Is the campaign on track to receive its forecasted revenue?
  • How is this campaign performing compared to last year?

Data Studio has a new Gauge Chart, giving users more options to customize these charts and tailor them to highlight the important details that your stakeholders value most. A Gauge Chart is a type of data visualization often used to display a single data value with a quantitative context. With a shape that resembles a speedometer, this chart aims to track the progress of a KPI in comparison to a set target or to other time periods. It provides a quick view of how well a metric is performing in comparison to your goals. Updates in making the Gauge Charts a more effective tool include:

  • Visualizing KPI’s by quarter
  • Set ranges within the Gauge to visualize the progress on your targets and goals
  • Compare your progress to previous periods of time
  • More color and font styling options

Not only do Gauge Charts make your reports more visually appealing, they’re very simple to create, improve storytelling by spotlighting key metrics, and they allow stakeholders to easily understand the data being presented to draw conclusions.

In this post, you will learn how to configure a Gauge Chart in Data Studio and how to customize it for the most effective reporting.

How to Configure a Gauge Chart

  1. Ensure that your dashboard is connected to a data source. For this example, the Google Merchandise Store is used as the data source. You can check the data source you are connected to in Data > Data source.Data Source
  2. In the toolbar, click Add a chart and scroll to the bottom to select Gauge with ranges.Add a chart
  3. Drag and drop a metric from the Available Fields section or click on the current metric for a dropdown list in under Data > Metric to select the metric you would like to showcase.Choose metric

Your Gauge Chart is Now Configured! What’s next?

Customize your chart to fit your stakeholders’ goals and brand.

Date Range Comparison

Add a date range comparison to compare how your metrics are doing now, compared to a previous date.

  • Go to Data > Default date range > select custom. First add the current date range you would like to see then under compassion date range, add the date you would like to compare it to. A black vertical bar will indicate where the metric was in the comparison date.
    Date Range Comparison Date Range Comparison Chart

The remaining customizations can be found in the Style Panel.


Primary Metric

You have the option to display your primary metrics as a whole number or compact number.
You can also choose the number of decimal points.


Bar Colours

The first option allows you to change the colour of the inside line. The second option allows you to choose the colour of the date range, around the inside line.

In the image below, the inside line colour changed to orange and the outer line to light blue to match the colours of ClickInsight.

Bar Colours Bar Colours - Chart Example

Comparison Metric

Change the colour of the comparison metric’s increase and decrease. Like the primary metric, you can display the number change as a whole or compact number showing your preferred decimals. And you have the option to display the change as a percentage or absolute number.

Comparison Metric Comparison Metric - Chart Example

Range Limits

Add a range of dollar amounts or time frames such as fiscal quarters. Up to 5 thresholds can be set up.

In the image below, the dollar range has been split into quarters, differentiated by different shades of blue, totaling $1 million.

Range Limits Range Limit - Chart Example

Axis

Set a minimum and maximum value to show your target goal for your metric.

Axis Axis - Chart Example

Target

Add a target to display the goal you are working towards. Mark the Show Target checkbox then enter the target value. The target line will appear as a black vertical line on the chart.

Note that currently there is no customization option to differentiate the comparison date range line with the target line.

Target Target - Chart Example

Missing Data

Use this option when there are gaps in your data. There are 5 options. Select the option that best matches the gaps in your dataset.

Use the Labels and Background and Border sections in the Style panel to further customize the colours, fonts, and look of your dashboard.

Now that you know how to create a Gauge Chart, you can create your own for reporting! Have questions about other features in Data Studio or how to take your dashboards to the next level? Drop a comment below or contact us at contact@clickinsight.ca.


Other Posts in Our 2021 Data Studio Series:
  1. Create Calculated Fields in Blended Data Source Tables with Data Studio
  2. Gain Insights on Data Studio Reports in Google Analytics
  3. Understanding the Advantages of Geo Charts & Google Maps in Data Studio
  4. Enhance GA4 Reporting Functionality with Calculated Metrics in Data Studio
  5. The Quick Reference Guide to GA4 Ecommerce Data in Data Studio
  6. Key Storytelling & Visualization Elements for Meaningful Stakeholder Reports
  7. Turn Up the Dial on your Dashboard Design with New Gauge Charts (this post)
  8. Visualize Your User Journey with Horizontal Bar Charts in Data Studio
  9. Taking Advantage of Data Studio Community Connectors
  10. Time Saving Layout Features You Should Be Using in Google Data Studio
  11. Quick Introduction of the New Report Publishing Control in Data Studio
  12. Guide to Collaboration & Transfer Ownership Features in Data Studio
By |2021-12-21T13:07:31-05:00December 14th, 2021|0 Comments
Categories: Data Studio, General

Leave A Comment