Creating a gauge chart

Use a gauge chart to measure performance against a goal that you set, like total annual sales or number of sales opportunities.

Set the number that the gauge starts at, often 0, and the goal — the number that indicates the gauge has reached 100% and is full.

The gauge color is based the percentage of the goal reached and the ranges you define.

Like all Quick Base charts, gauge charts are interactive; click the colored portion of the gauge to view the records included in the measurement. You can also apply dynamic filters to gauge charts.

To print your chart or save it as an image, click the menu in the top right of the chart:

To create a gauge chart:
  1. Open the table in the table bar, click REPORTS & CHARTS and then click + New.

  2. Select Chart and click Create.

  3. In the Basics section, Name your chart and give it a Description.

    Tip: Select Show description on chart page so others can easily understand the purpose of your chart.

  4. Select Gauge as the chart Type.

  5. Decide what the gauge measures:

    • Select the field you want to measure and decide whether you want to sum or average the values. If you want to define a calculated column to display in the chart, select Calculated column, and then define the calculated formula in the Options section.

    • Enter an Axis label. This displays in the center of the gauge.

  6. Set the Gauge limits.

    • Enter the number that the gauge will Start at.

    • Will the goal be a plain number? If so choose Number from the Goal type dropdown. If the goal will be based on data from your table, choose Data value.

    • Choose a field or enter the Goal number. When you choose a field, the goal becomes the sum or average of that field across all records in the table.

    The gauge is empty when the value you're measuring is less than the Start number. It's full when the value is equal to or greater than the Goal.

  7. Set the range values. These values indicate the color of the gauge.

  8. If you chose to measure a Calculated column or set it as the goal, select define a calculated column, label it, create the formula, and select the type.

  9. If desired, filter to display only certain types of data or data that meets conditions you set.

  10. Save the chart as Personal (only you can view it) or Common (others can view it). Optionally, you can also assign the report to a group.

About setting ranges

The gauge displays in a single color. The color is determined by the percentage of the goal reached and the range you define for each color.

For example, you might choose red if the value is less than 25% of your goal, yellow if the value is from 25% up to 50% of your goal, and green if the value is greater than 50% of your goal.

Enter a percentage of the goal to define each color range
Low: Values less than the percentage you enter here display in the color defined for Low.
Medium: Values up to the percentage you enter here display in the color defined for Medium.
High: Values above the Medium range display in the color defined for High.

About customizing colors for gauge ranges

You can customize the colors for Low, Medium, and High ranges in the Legend at the top of the Chart Details area.

Example

This gauge measures total annual sales against the goal of 1,400,000.

This gauge chart is defined to:

  • Measure the Sales, which is summed.

  • Start at 0 and become full at its Goal of 1,400,000.

  • Display the following colors:

    • Low (red), if the values are up to 50% of the goal.

    • Medium (yellow), if the values are above 50% but less than 90% of the goal.

    • High (green), if the values are above 90% of the goal.

Related Topics:

 

Go back

Did this help you? Give us a rating:

           

© 1999-2019  QuickBase, Inc.  All rights reserved.  Legal Notices.