Gauges in ConnectWise Report Writer

The Gauge tab lets you build a panel of gauges grouped by any field in your dataset — for example, open ticket counts grouped by Service Board.

Gauge types

Type	Behavior
Radial	Static needle that sweeps from 90° (straight up) to 0° (pointing right).
Radial 2	Same sweep as Radial with a different visual style.
Animated Half Circle	Animates from 180° (pointing left) to 0° (pointing right). Unlocks KPI and update-frequency options.
Animated Half Circle with KPIs	Like Animated Half Circle, but highlights a target zone on the arc.
Linear	A horizontal bar that fills left to right.

Gauge options

Option	Description
Title	Label for the gauge panel on the report.
Results	Number of gauges to show (one per grouped result).
Name	Field to use as the grouping label for each gauge.
Value	Numeric field to use as the gauge’s data value.
Sort	Field to sort by. Use Maximum or Minimum to sort alphabetically.
Minimum	Lower bound of the gauge scale.
Maximum	Upper bound of the gauge scale.
Color	Color or color ranges for the value bar. Applies to Radial, Radial 2, and Linear gauges.
Gauge Style	Which gauge type to display.
KPI Low	Lower bound of the target zone. Available when Animated Half Circle is selected.
KPI High	Upper bound of the target zone. Available when Animated Half Circle is selected.
Update	How often the gauge refreshes — useful for dashboards tracking live data.
Red Values	Which side of the target zone to mark as a hazard. Hide (default): no hazard zone. Low: values below the target zone turn red. High: values above the target zone turn red.
Target Report	A subreport to display on hover when a user mouses over the gauge (drill-down). Uses the Name field as the drilldown key.

Build a gauge panel

The steps below create a panel showing open ticket counts per Service Board.

1. In Report Writer, open your report and go to the Gauge tab.
2. In Name, select the grouping field — for example, the Service Board field.
3. In Value, select your numeric field — for example, ticket count.
4. Set Minimum and Maximum to define the scale.
5. In Gauge Style, choose the gauge type you want.
6. Optionally, set Results to limit how many gauges appear.
7. Select Save.

Set color ranges

To define color bands on the gauge:

1. In the Color field, enter a percentage range or an absolute value range for each color.
2. Add as many ranges as needed — for example, 0–50% green, 51–80% yellow, 81–100% red.

Color ranges apply to Radial, Radial 2, and Linear gauge types only.

KPIs and auto-updating data

Selecting Animated Half Circle unlocks the KPI Low, KPI High, Red Values, and Update fields.

• Set KPI Low and KPI High to define the acceptable target zone on the arc.
• Use Red Values to flag whether values below or above the target zone should appear in red.
• Use Update to set an auto-refresh interval if the underlying data changes frequently.

Add a drill-down report

Set Target Report to a subreport. When a user hovers over a gauge, the subreport opens, filtered by that gauge’s Name field value — the same drill-down behavior available in standard Report Writer reports.