Gauges

Top  Previous  Next

Overview

 

Gauges can be used to reflect up to two values and can be used, for instance, to see the performance of a measure compared to a target.

 


 

Adding Data

 

Data fields are bound to Gauges by dragging them to the Data Items Pane as an Actual, Target or a Series.

 

Additionally, Hidden Data Items can be used for additional configurations, such as filtering, without displaying the field on the Dashboard Item.

 

Working with Gauge Data

 

Each Dashboard Item has different requirements for the data you add to it.

 

As mentioned above, Gauges use Actuals, Targets (optional) and Series.

 

The aggregated value is compared to the target, and when using a target, the Gauge can also reflect a defined Delta.

 

Each Data Item can be formatted by hovering over the item and clicking the options icon (right aligned down arrow).

 

Actual - Actual data to display on the Gauge
Target - Target data to display on the Gauge
Series - Data Item for which the Gauge is displayed. Using a Series allows you to see multiple Gauges across several data items- Years, Projects, Employees, etc).

 

Consider the following example for viewing Employee Performance (or Utilization).

 

Actual

Target

Series

Direct Hours PCT (Avg)

Target field (Max)

Employee Name

 

This would reflect a Gauge for each employee indicating their billable percentage in relation to the target. You’ll also see an indicator representing the Delta - the difference between the actual and the target.

 

Multiple Gauges

 

Gauge Dashboard Items allow you to build multiple gauges per dashboard item.

 

When filling the Actual and Target placeholders, you’ll notice a new set of empty placeholders appear. If applicable, drag and drop a new set of comparisons and the gauge will create a Value icon (stack seen in the upper-right hand corner of the dashboard item) which you can use to switch between gauges.

 

TIP: If you’ve added data but don’t see it reflected, click the Refresh button above the Field List in the Data Browser (left-hand pane of the designer).

 


 

Formatting

 

Data added to Gauges is automatically formatted based on the data type. That said, formats can be edited by clicking Options from the data item (Options Button- down arrow - becomes visible when hovering over the data field in the Data Items pane).

 

For instance, if using a percentage, you would likely need to change the format to type: Percent. Likewise, if using a date as your series, you may want to see that broken out in to quarters or months (etc.)

 

Numbers / Currency

 

To change the format for numbers or currency, hover over the data item in the Data Items pane and complete the following:

 

1.Click the Options button (down arrow)
2.Select Format…
3.Configure settings as appropriate (see below)
4.Click OK

 

Format Type - Defaults to Auto. Options include: General, Number, Currency, Scientific, Percent.
Unit - Unit to which values should be converted
Precision - Defines the decimals to display
Currency - Defaults to Dashboard global currency setting. Specific currency settings can be set here.
Culture - Defines the currency cultures for currencies with multiple cultures
Include group separator - Displays a comma between each numeric group (e.g. 1,000,000.00)

 

Date Values

 

Date Values have several display options, listed when clicking the Options button. To change display settings, hover over the data item in the Data Items pane and complete the following:

 

1.Click the Options button (down arrow)
2.Select the Date type (e.g. Year, Quarter, etc)
3.Optionally set the Format
oDefault
oFull (e.g. Month = October, etc.)
oAbbreviated (e.g. Month = Oct, etc.)
oNumeric (e.g. Month = 10, etc.)
oLong (e.g. Date-Hour = Saturday, October 15, 2016 10:57pm (en-US))
oShort (e.g. Date-Hour = 10/15/2016 10:57pm (en-US))
oTime Only (e.g. Date-Hour = 10:57pm (en-US))

 

Gauge Scale

 

Gauge data is represent based on a gauge scale which can be auto-assigned or customized.

 

This can be configured by clicking the Gauge Options icon (gear to the right of the Actual/Target placeholders in the Data Items pane).

 

Scale Options include:

 

Minimum value - Min value for the gauge- typically zero (0).
Maximum value - Max value for the gauge
Auto - Automatically sets min and max based on the displayed values.

 

Delta

 

As mentioned above, Deltas represent the difference between the Actual and the Target used on the Gauge.

 

Deltas will reflect in the form of an indicator (whether the actual exceeds the target or not) and a number.

 

Deltas can be configured by clicking the Gauge Options icon (gear to the right of the Actual/Target placeholders in the Data Items pane).

 

Delta Options include:

 

Value Type - Specifies which value type should be displayed as the Delta on the Gauge
Result Indication - Sets the logic for the delta indicator. Indicators include a green up-arrow (positive result), a red down-arrow (negative result) and a yellow warning circle.
oGreater is good - Displays positive if the actual exceeds the target
oLess is good - Displays positive if the actual doesn’t exceed the target
oWarning if greater - Displays a warning if the actual exceeds the target
oWarning if less - Displays a warning if the actual does not exceed the target
oNo indication
Threshold Type -  Further rules can be applied to when a visual indicator will be displayed in the result (e.g. display a green up-arrow only if the actual exceeds the target by 15% or $1500.00, etc.). Threshold Type defines the type of threshold to apply- percent or absolute value.
Threshold Value - Sets the value for the threshold (e.g. 15%, $1500, etc.).

 


 

Gauge Tools

 

Gauges feature a specific set of design and data tools, available from the toolbar (some options are also available by right-clicking the chart).

 

All toolbar items feature tool tips which explain (in short) the core functionality of the toolbar option.

 

Data Tab

 

The Data Tab includes several options for data shaping.

 

Edit Filter - Use to add/edit filters on the grid based on displayed or Hidden Data Items.
Clear - Clears all filters
Single Master Filter - This sets the selected Dashboard Item (e.g. Gauge, etc) as a Master Filter for all other dashboard items. Using a Single Master Filter you can only filter by one element in the selected item.
Multiple Master Filter - This sets the selected Dashboard Item (e.g. Gauge, etc) as a Master Filter for all other dashboard items. Using a Multiple Master Filter you can filter by one or more elements in the selected item. Multiple items can be selected by using Ctrl+Click.
Drill Down - Enables drill-in details for the Dashboard Item. For Gauges, list multiple Series in order of detail - least to most. When enabled the gauge will reflect data for the top series, allowing you to click (double-click if also using Master Filter) through to each subsequent series, displaying values in relation to each.
Cross Data-Source Filtering - Allows a Master Filter to affect data items displaying data from other data sources.
Ignore Master Filter - Dashboard Items can interact with other dashboard items marked as a Master Filter. Clicking Ignore Master Filter removes interactivity.

 

Design Tab

 

Gauges allow the following design options.

 

Show Caption - Shows/Hides the caption (e.g. “Grid 1” displayed at the top left of the dashboard item).
Edit Names - Used to configure display name for the Dashboard Item
Auto Arrange - Automatically arranges the gauge to fit the dimensions of the dashboard item.
Arrange in Columns - Arranges the gauges in a defined number of columns- configured by the Count ticker.
Arrange in Rows - Arranges the gauges in a defined number of rows- configured by the Count ticker.
Full Circular - Sets the Gauge style to full circle
Half Circular - Sets the Gauge style to half circle
Left/Right Quarter - Sets the Gauge style to quarter circle
Three Fourths Circular - Sets the Gauge style to 3/4 circle
Linear Horizontal - Displays the gauge on a horizontal line
Linear Vertical - Displays the gauge on a vertical line
Show Gauge Captions - Show/Hide the series label (e.g. label listed above the gauge)