Adding a Calculated Measure to a Pivot Chart

Use a Calculated Measure to display the mathematical relationship between two measures directly in a Pivot Chart — without creating custom fields. Calculated Measures are useful for displaying KPIs such as compliance percentages, coverage rates, and asset ratios.

A Calculated Measure counts as a single measure toward the visualization's measure limit. For example, a visualization that supports one measure can display either one standard measure or one Calculated Measure.

Adding a Calculated Measure

[SCREENSHOT: Chart Wizard with the Metrics section visible, showing the "+ Measure" and "+ Calculated Measure" buttons — corresponds to Screenshot 1]

1. In the Chart Wizard, configure the Visualization, Data, and Dimensions sections for your Pivot Chart. See Pivot Chart.

2. In the Metrics section, click + Calculated Measure.

   Two measure rows appear, connected by an Operator selector.

   [SCREENSHOT: Metrics section after clicking "+ Calculated Measure", showing the two "Select Field" rows and the Operator dropdown — corresponds to Screenshot 2]

3. For the first measure row:

   • Select an adapter source.
   • Select a field.
   • Select a calculation function (Count, Sum, Average, Count True, or Count False). The available functions depend on the selected field type.

4. Select an Operator:

   [SCREENSHOT: Operator dropdown open, showing all five options — corresponds to Screenshot 4]

   • % Percentage of (default) — Calculates the first measure as a percentage of the second measure using the formula (Measure A / Measure B) × 100. The result is displayed with a % symbol.
   • + Add to — Adds the two measures.
   • − Subtract — Subtracts the second measure from the first.
   • × Multiply by — Multiplies the two measures.
   • ÷ Divide by — Divides the first measure by the second.

5. For the second measure row, select an adapter source, a field, and a calculation function.

6. To rename the Calculated Measure, click the edit icon next to the measure row. The Edit Field dialog opens.

   [SCREENSHOT: Edit Field dialog, showing the "Field Display Name" input and the "Use short notation K/M/B" toggle — corresponds to Screenshot 6]

   • Field Display Name — Enter a custom name for the measure column. By default, Axonius generates a name in the format <Measure A> <Operator> <Measure B> (for example, Host Name count Percentage of Asset Name count).
   • Use short notation K/M/B (1,000 → 1k) — Enable to display large numbers in abbreviated format.

   Click Apply to save your changes.

7. Click Save to save the chart.

   [SCREENSHOT: Chart preview showing the Table visualization with the OS:Type column and the calculated measure column — corresponds to Screenshot 5]

Combining Calculated Measures with Other Measures

The following rules apply when adding multiple measures to a Stacked or Timeline visualization:

• The first configured measure determines which measure types are available for that visualization.
  • If the first measure is a Percentage of Calculated Measure, all additional measures must also be Percentage of Calculated Measures. The option to add a standard measure and all non-percentage operators are unavailable for additional measures.
  • If the first measure is a standard measure or a non-percentage Calculated Measure, you can add additional standard measures and Calculated Measures, but Percentage of is unavailable for additional Calculated Measures.
• Unavailable options remain visible with an info icon that explains the restriction.
• If you remove all measures, all measure types and operators become available again.

Click-Through Behavior

When you click a data point in a Pivot Chart that uses a Calculated Measure, the resulting asset table includes the fields used by both underlying measures. If both measures use the same field, the field appears only once.