Gauge

Angular gauge

Angular gauge

• Axis parameter - Month

• Values parameter - Actual, Plan, 2024 Actuals, 2024 Plan, Created visual measures for demonstration purposes

• Chart type - Vertical Linear gauge

• Description - Angular gauges are ideal for displaying a single key performance indicator (KPI), such as system utilization, completion percentage, or performance scores.

Angular gauge pivot data

The Min and Max values specify the range of values between which the actuals and target should lie.

When the secondary actuals and target are not assigned, a single gauge will be plotted.

1. Conditional formatting for Angular gauges

Use the Conditional formatting > Comparison band option to easily compare values visually against predefined benchmarks.

Comparison band for angular gauges

2. Canvas settings for Angular gauges

2.1. Gauge type

You can plot semi-circular or circular gauges.

Circular gauge

2.2. Primary

• Needle: Render a needle to denote the actuals.

Needle to depict actuals

• Remaining fill: Customize the color of the gauge. It is set to light grey by default.

Remaining fill

• Actuals: Customize the appearance and color of the Actuals measure.

Actuals customization

• Target: Customize how the target is represented. You can render a circle or a line.

Target customizations

2.3. Secondary

When a secondary actual and target are assigned, you can customize the second gauge with the same options discussed in the previous section.

Linear gauge

Linear gauge

• Axis parameter - Month

• Values parameter - Actual, Plan, Created visual measures EnhcPlan, PlanMax, and PlanMin

• Chart type - Vertical Linear gauge

• Description - Linear gauges offer a minimalistic solution for showing progress toward a goal, such as tracking KPIs or completion percentages. Since they are vertically oriented, they can easily be accommodated in dashboards.

Pivot data for linear gauge

Linear gauge with min and max points defined - you can specify the minimum and maximum cutoff values between which to plot the gauge.

Linear gauge with minimum and maximum cutoff

1. Conditional formatting for Linear gauges

Use the Conditional formatting > Comparison band option to easily compare values visually against predefined benchmarks.

Comparison bands for linear gauges

2. Canvas settings for Linear gauge

2.1. Linear gauge type

Choose between Qualitative linear, Regular linear, and Progress bars.

Linear gauge

Progress bar

Qualitative linear gauge

2.2. Rounded edge

Soften the corners by enabling the rounded edge option.

Rounded edge

2.3. Actuals

Customize the color and appearance of the AC measure.

AC customization

• Width: Set the width of the Actuals bar.

AC width

• Marker: Enable/disable the marker for AC. You can also set the style (Triangle/Diamond/Circle/Square/Line) and color.

AC marker shape and color

• Size: Set the size of the marker.

AC marker size

2.4. Target

Enable the toggle to plot the target. Set the style, size, and color of the target marker.

Target marker customization

2.5. Gauge width

Set the thickness of the gauge.

Gauge width

2.6. Remaining width

Choose a different color for the gauge. It is set to light grey by default.

Fill color for the Gauge