Gauges are output controls that display a visual representation of a cell value in the user interface. Widely used in data analysis and presenting key metrics, gauges are a vital component of dashboard reports. Each gauge must be associated with a Single Named Range (SNR) from the workbook.

Inserting a gauge into the web interface can be done by dragging and dropping a Gauge module from the context menu into the staging area of the User Interface Designer.

Once placed, click on the gauge to define its properties from the right-hand menu. Begin by selecting the Single Named Range (SNR) that contains the target data for the gauge from the Single Named Range selection. This value should include the data to be displayed on the gauge.

Select from available styles from the Type menu. Other configuration options will populate based on your style selection.

There are three types of gauges available:

  • Standard Gauges: Standard gauges are excellent for tracking progress or completion rates. Critical success factor, GPA, or performance score analyses are common examples. Min Value and Max Value determine the start and end points drawn on the gauge. You can enter a string into the Label field to add a header. Number Format allows customizing the numerical formatting of the values.
  • Dial Gauges: Dial gauges are excellent for tracking progress or completion rates. Critical success factor, GPA or performance score analyses are common examples. Min Value and Max Value determine the start and end points drawn on the gauge. You can enter a string into the Label field to add a header. Number Format allows customizing the numerical formatting of the values.
  • Digital Gauges: Digital gauges act like an interactive display card; they show a quantity in a fancy way. This gauge type can be used to report inventories, or “X Interval to Date” totals. You can enter a string into the Label field to add a header. Number Format allows customizing the numerical formatting of the values.