{ "api_version": "1", "kind": "dse_post", "self": "https://update.dsesecurity.com/api/v1/posts/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/", "item": { "id": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/", "slug": "dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit", "url": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/", "alternate_urls": { "markdown": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit.md", "json": "https://update.dsesecurity.com/api/v1/posts/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/" }, "title": "Make a workbook stat card's first-row behavior explicit", "summary": "Does an Azure workbook stat card automatically show the latest value or total from a multirow query?", "format": { "slug": "briefing", "name": "Briefing" }, "priority": { "slug": "info", "name": "Information" }, "featured": false, "image": { "theme": "continuity-recovery", "label": "Continuity & recovery", "alt": "Paired infrastructure paths converging on a stable recovered service.", "card_url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-card.webp?v=1.8.20", "hero_url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-hero.webp?v=1.8.20", "social_url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-social-v2.jpg?v=1.8.20", "width": 2400, "height": 1350 }, "topics": [ { "slug": "business-continuity", "name": "Business Continuity", "url": "https://update.dsesecurity.com/topic/business-continuity/" }, { "slug": "it", "name": "IT", "url": "https://update.dsesecurity.com/topic/it/" } ], "author": { "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/#editorial-team", "type": "Organization" }, "publisher": { "name": "Detection Systems & Engineering", "url": "https://dsesecurity.com/" }, "published_at": "2026-09-10T00:23:37+00:00", "modified_at": "2026-09-10T02:08:05+00:00", "reviewed_on": "2026-09-09", "reading_minutes": 2, "word_count": 243, "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.", "primary_source": { "name": "Azure Workbooks stat visualizations - Azure Monitor | Microsoft Learn", "url": "https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-stat-visualizations", "published_on": null, "authority": "Microsoft Learn" }, "publishing_principles": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/", "usage_info": "https://update.dsesecurity.com/usage/", "copyright_notice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.", "content_html": "

Source facts

\n

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.

\n

Applicability

\n

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.

\n

DSE recommendation

\n

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.

\n

Verification

\n

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.

\n

Official references

\n

Microsoft Learn: Workbook Stat visualizations. Source reviewed September 9, 2026.

", "content_text": "Source facts\nA 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.\nApplicability\nReview 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.\nDSE recommendation\nSpecify 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.\nVerification\nUse 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.\nOfficial references\nMicrosoft Learn: Workbook Stat visualizations. Source reviewed September 9, 2026.", "content_markdown": "## Source facts\n\nA 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).\n\n## Applicability\n\nReview 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.\n\n## DSE recommendation\n\nSpecify 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.\n\n## Verification\n\nUse 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.\n\n## Official references\n\n[Microsoft Learn: Workbook Stat visualizations](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-stat-visualizations). Source reviewed September 9, 2026." }, "json_ld": { "@context": "https://schema.org", "@graph": [ { "@type": "Organization", "@id": "https://dsesecurity.com/#organization", "name": "Detection Systems & Engineering", "alternateName": "DSE Security", "url": "https://dsesecurity.com/", "logo": { "@type": "ImageObject", "url": "https://update.dsesecurity.com/assets/dse-logo-20260812.png?v=1.8.20" } }, { "@type": "Organization", "@id": "https://update.dsesecurity.com/#editorial-team", "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/", "parentOrganization": { "@id": "https://dsesecurity.com/#organization" } }, { "@type": "WebSite", "@id": "https://update.dsesecurity.com/#website", "name": "DSE Updates", "alternateName": "DSE Security Knowledge Hub", "url": "https://update.dsesecurity.com/", "inLanguage": "en-US", "publisher": { "@id": "https://dsesecurity.com/#organization" }, "potentialAction": { "@type": "SearchAction", "target": { "@type": "EntryPoint", "urlTemplate": "https://update.dsesecurity.com/?q={search_term_string}" }, "query-input": "required name=search_term_string" } }, { "@type": "WebPage", "@id": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/", "url": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/", "isPartOf": { "@id": "https://update.dsesecurity.com/#website" }, "lastReviewed": "2026-09-09" }, { "@type": "BreadcrumbList", "@id": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/#breadcrumbs", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "DSE Updates", "item": "https://update.dsesecurity.com/" }, { "@type": "ListItem", "position": 2, "name": "Make a workbook stat card's first-row behavior explicit", "item": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/" } ] }, { "@type": [ "Article", "TechArticle" ], "@id": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/#article", "identifier": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/", "url": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/", "headline": "Make a workbook stat card's first-row behavior explicit", "description": "Does an Azure workbook stat card automatically show the latest value or total from a multirow query?", "abstract": "Does an Azure workbook stat card automatically show the latest value or total from a multirow query?", "articleBody": "Source facts\nA 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.\nApplicability\nReview 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.\nDSE recommendation\nSpecify 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.\nVerification\nUse 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.\nOfficial references\nMicrosoft Learn: Workbook Stat visualizations. Source reviewed September 9, 2026.", "datePublished": "2026-09-10T00:23:37+00:00", "dateModified": "2026-09-10T02:08:05+00:00", "mainEntityOfPage": { "@id": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/" }, "inLanguage": "en-US", "isAccessibleForFree": true, "author": { "@type": "Organization", "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/#editorial-team" }, "publisher": { "@id": "https://dsesecurity.com/#organization" }, "image": { "@type": "ImageObject", "@id": "https://update.dsesecurity.com/updates/dse-20260909-499-make-a-workbook-stat-card-s-first-row-behavior-explicit/#primaryimage", "url": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-social-v2.jpg?v=1.8.20", "contentUrl": "https://update.dsesecurity.com/assets/editorial/continuity-recovery-social-v2.jpg?v=1.8.20", "width": 1200, "height": 630, "caption": "Make a workbook stat card's first-row behavior explicit" }, "articleSection": [ "Business Continuity", "IT" ], "keywords": [ "Business Continuity", "IT", "Briefing", "Information priority" ], "genre": "Briefing", "about": [ { "@type": "Thing", "name": "Business Continuity", "url": "https://update.dsesecurity.com/topic/business-continuity/" }, { "@type": "Thing", "name": "IT", "url": "https://update.dsesecurity.com/topic/it/" } ], "wordCount": 243, "timeRequired": "PT2M", "publishingPrinciples": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/", "usageInfo": "https://update.dsesecurity.com/usage/", "copyrightHolder": { "@id": "https://dsesecurity.com/#organization" }, "copyrightNotice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.", "citation": { "@type": "CreativeWork", "name": "Azure Workbooks stat visualizations - Azure Monitor | Microsoft Learn", "url": "https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-stat-visualizations" } } ] } }