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:

  6. Set the Gauge limits.

    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:

Related Topics:

 

Go back      |       |   

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