Gauge Control

Owned by Migration (Unlicensed)
Last updated: Apr 19, 2016 by Nadica Gaber (Unlicensed)
3 min read

Introduction

This control is a part of Free Format Report and allows to analyze the company's KPI values as opposed to the defined target values. For instance, you may want to compare your actuals to the budget values, or previous month performance or peer performance. Please, refer to the Gauge Control article for detailed information.

Settings

The report settings define the look & feel of a report:

CONTENT

Control Parameters

Setting

Description

Mandatory

Data Source

Select the list containing the gauge sections

Yes

 

Labels, Formats and Colors

 

Setting

Description

Mandatory

Title

 Title of the Gauge Chart Control

No

Chart format

A format can be chosen from the /wiki/spaces/CXO60/pages/43811292 list. This Format relates to the colors of the gauge elements: needle, numbers, background. Specify "Fore Color" for the numbers, "Back Color" for the needle, "Chart Series Color" for the background, "Chart Shape Color" for the background additional color. If you want to have a monocolor background, set "Chart Series Color" and "Chart Shape Color" to the same color.

Yes

Scale

This defines the /wiki/spaces/CXO60/pages/43811287 used in the report. It can be overruled by the scaling in the Lists.

Yes

Precision

Defines the number of decimals used for presenting the number. Options are 0-6. Similar to the Scale setting, The Precision setting is the default for all data in the report, but can be overruled by a specific (not -1) precision in the List.

Yes

 

Layout

Setting

Description

Mandatory

Gauge radius

Indicates outer radius of the Gauge. Use 0 for auto size

Yes

Scale radius

Indicates the radius of the scale. Use 0 for auto size

Yes

Scale ModeWhether Scale mode is Auto or ManualYes

Number of intervals

Determines number of major intervals on the gauge chart.

Yes

Range distance from scale

Determines the distance between the scale and the ranges

Yes

Half-Circle

Allows to use a full or half-circle as gauge chart

Yes

How to create a Gauge Chart

The behavior of the Gauge chart is defined by the list, used in the Data Source Parameter.

You can create a Gauge chart with the fixed values or a dynamic chart, which will change the behavior based on the item, picked from the related Item Selector (see External Item Selector report parameter).

Example

Let's consider an example of a dynamic report, which will allow to pick different accounts for the Gauge chart.

To achieve this we will combine a Gauge chart with an External Item Selector Control, also available in the Free Format Report.

1. First we will  include there several accounts in a List that is cretaed to be Item selector:

2. Then we will create the list, which will be used as a Gauge Data Source. Only Category dimension will be included in the list, as the account value will be defined by the Item Selector.

 

 

3. Now define the following Report Settings:

  • Set the Item Selector setting to the list from Step 1
  • Set the Data Sourcesetting to the list from Step 2
  • Set the Half-Circle Setting to Yes

As a result, we will get the following Gauge Chart which display the values for any account, picked from the Item Selector:

 

See Also

Free Format Report