Overview

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.

Basics

Inserting a Gauge

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.

Gauge Data Structures

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
• Dial Gauges
• Digital Gauges

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.

Color Scheme

The color set of the gauge. You can customize your gauges' colors as you desired by clicking to Edit Color Scheme button. If a color set is not selected then it will use default color set from the Edit Application page.

Visible

The Visible property sets the conditions under which the gauge will be visible. This can be set to Always or Never.

If there are any Boolean Named Ranges (BNR) defined in your workbook (i.e. single named ranges that evaluate to TRUE or FALSE), then an additional option (By Value Of) will be available. This option allows you to configure a Boolean named range that determines whether or not this section is visible. This can either be calculated or input-based.