# Make a workbook stat card's first-row behavior explicit

> Does an Azure workbook stat card automatically show the latest value or total from a multirow query?

- Canonical URL: https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/
- Publisher: Detection Systems & Engineering (DSE Security)
- Author: DSE Security Editorial Team
- Published: 2026-09-10T00:23:37+00:00
- Modified: 2026-09-10T02:08:05+00:00
- Last reviewed by DSE: 2026-09-09
- Resource type: Briefing
- DSE priority: Information
- Topics: Business Continuity, IT
- Reading time: 2 minutes

## What you need to know

Does an Azure workbook stat card automatically show the latest value or total from a multirow query?

## Potentially affected

Azure workbook Stat visualizations displaying a selected column from multirow query results.

## DSE recommendation

Specify whether the card should show one chosen row or an explicit aggregation, and label that meaning beside the value.

## Article

## Source facts

A workbook Stat visualization can display a single value or aggregate multiple query rows. For the documented multirow time-series example, its default is the first value, not an automatic latest-value or total calculation. Selecting an aggregation applies that function to the chosen column. Tag text provides the label below the main value, and a custom tooltip can add context. [Microsoft Learn](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-stat-visualizations).

## Applicability

Review cards fed by more than one row, particularly where the heading implies a current state or an interval total. Inspect the query output order and visualization settings together before deciding what the displayed number means.

## DSE recommendation

Specify whether the card should show one chosen row or an explicit aggregation, and label that meaning beside the value. Ask the workbook owner to make any selected-row ordering deliberate in the query. Use an aggregation only when its mathematical meaning fits the requested metric. Include the relevant interval or observation context in the label or tooltip so readers do not have to infer it from a large number.

## Verification

Use a small synthetic result with visibly different first, last and aggregate values. Check which value the card displays under the proposed configuration, then reorder the test rows to expose an unintended first-row dependency. Compare the accepted result with the card’s label. Preserve the query and visualization settings together; styling or threshold colors should not distract from an incorrect underlying selection.

## Official references

[Microsoft Learn: Workbook Stat visualizations](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-stat-visualizations). Source reviewed September 9, 2026.

## Primary reference

- Name: Azure Workbooks stat visualizations - Azure Monitor | Microsoft Learn
- Authority: Microsoft Learn
- URL: https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-stat-visualizations
- Source publication date: Not stated by the source

## Citation and use

Preferred citation: “Make a workbook stat card's first-row behavior explicit,” DSE Security, https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/
Publishing principles: https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/
Usage and citation policy: https://update.dsesecurity.com/usage/
Copyright © 2026 Detection Systems & Engineering. All rights reserved.