Stat visualizations

Azure Workbooks let you easily query and combine data from different Azure subscriptions into a single metric. You can customize how this metric looks, including text and background colors, font sizes, and set up thresholds that change icons and colors based on the value.

Stat helps you create dashboards that give you instant alerts when a service is healthy or unhealthy, or when important metrics drop below a certain level. This way, you stay informed and can quickly respond to critical changes.

Add a stat

1. Switch the workbook to edit mode by selecting Edit.

2. Use the Add query link to add a log query control to the workbook.

3. For Query type, select Azure Resource Graph. For Resource type, select, for example, Application Insights, and select the resources to target.

4. Use the query editor to enter the KQL (Kusto Query Language) for your analysis.

   requests
   | where name !endswith('.eot')
   | summarize Requests = count(), Users = dcount(user_Id) by name
   | order by Requests desc
   

5. Set Visualization to Stat.

6. Select the Stat Settings button to open the Stat Settings pane:

   • In Use column, set: Requests
   • In Tag text, set: # of requests
   • In Color settings, set:
     • Apply color from: Heatmap
     • Color palette: Red to Green
     • Minimum value: 0
     • Maximum value: 1,000

7. Select the Save and Close button at the bottom of the pane.

Single-value and aggregated data

Stat visualizations can display either a single data point from a query or aggregated data from multiple rows in a query result.

Single-value data

For instance, a single-value data structure might look like this:

For the above data, the visualization would display "OK" if the "Value" column is selected. This single value can be a number, string, or other data types.

Aggregated data

Stat visualizations can also process time series data and perform simple aggregations. For example:

For the above data, the visualization would display the first value by default. If an aggregation function is specified, it applies the function to the selected column's values, summarizing the data accordingly.

Stat settings

Applying color based on thresholds

Thresholds apply a specific color depending on the visualization's value meeting a specific condition.

1. Switch the workbook to edit mode by selecting Edit.

2. Use the Add query link to add a log query control to the workbook.

3. For Query type, select Azure Resource Graph. For Resource type, select, for example, Application Insights, and select the resources to target.

4. Use the query editor to enter the KQL for your analysis.

   ServiceHealthResources
   | where type =~ 'Microsoft.ResourceHealth/events' 
       and properties.EventType == 'ServiceIssue' 
       and properties.Status == 'Active'
   | summarize Status = iif(count() == 0, "OK", "Unhealthy")
   

5. Set Visualization to Stat.

6. Select the Stat Settings button to open the Stat Settings pane:

   • In Use column, set: Status
   • In Tag text, set: Service Health Status
   • In Color settings, set:
     • Apply color from: Thresholds
     • In the fields, create the first threshold:
       • Operator: ==
       • Value: Unhealthy
       • Color: Red (bright)
     • In the fields, create the second threshold:
       • Operator: ==
       • Value: OK
       • Color: Green

7. Select the Save and Close button at the bottom of the pane.

The query now displays a different color, depending on the resource health status of your queries.

Applying a heatmap-style color

When the Heatmap option is selected, the visualization's color is selected according to the gradient between the minimum and maximum value.

1. Switch the workbook to edit mode by selecting Edit.

2. Use the Add query link to add a query control to the workbook.

3. For Query type, select Azure Resource Graph. For Resource type, select, for example, Application Insights, and select the resources to target.

4. Use the query editor to enter the KQL for your analysis.

   ServiceHealthResources
   | where type =~ 'Microsoft.ResourceHealth/events' 
       and properties.EventType == 'ServiceIssue' 
       and properties.Status == 'Active'
   | summarize Count=count()
   

5. Set Visualization to Stat.

6. Select the Stat Settings button to open the Stat Settings pane:

   • In Use column, set: Count
   • In Tag text, set: Active Health Events Count
   • In Color settings, set:
     • Apply color from: Heatmap
     • Color palette: Green to Red
     • Minimum value: 0
     • Maximum value: 100

7. Select the Save and Close button at the bottom of the pane.

Depending on the value returned by the query in the Count column, the color falls within the gradient of the chosen palette.

Applying a static color

When the Static value option is selected, the Color field dictates which color is used for the stat.

Use cases

Querying AKS (Azure Kubernetes Service) clusters for resource usage

1. Switch the workbook to edit mode by selecting Edit.

2. Use the Add parameters link to add a parameters step to the query.

3. Select Add parameter, then configure the parameter:

   • Parameter name: Prometheus

   • Display name: Prometheus instance

   • Parameter type: Resource picker

   • Required: Checked

   • Get data from: Query

     • Set the query to:

       • Data source: Azure Resource Graph

       resources 
       | where type =~ "microsoft.monitor/accounts" and isnotempty(todynamic(properties).metrics.prometheusQueryEndpoint) 
       | project id
       

   • Select Save.

4. Select Add parameter, then configure the parameter:

   • Parameter name: TimeRange
   • Display name: Time range
   • Parameter type: Time range picker
   • Select Save.

5. Select Done editing to finish configuring the parameters.

   • Once the parameter queries finish loading, select the desired Prometheus instance you'd like to monitor.

6. Use the Add query link to add a query control to the workbook.

7. For Query type, select Prometheus.

8. For Azure Monitor workspace, under Resource Parameters, select Prometheus Instance.

9. For Time Range, under Time Range Parameters, select TimeRange.

10. For Visualization, select Stat.

11. For the query, choose which metric you'd like to monitor:

    • CPU Utilization:

      1 - avg(rate(node_cpu_seconds_total{mode="idle"}[5m]))
      

    • Memory Utilization:

      1 - sum( sum(
      node_memory_MemAvailable_bytes or
      (
           node_memory_Buffers_bytes +
           node_memory_Cached_bytes +
           node_memory_MemFree_bytes +
           node_memory_Slab_bytes
      )
      ) by (cluster)) / sum(node_memory_MemTotal_bytes)
      

12. For each metric, the value must be formatted. Select Stat Settings.

    • Check Custom number formatting.

      • Style: Percent

      • Minimum fractional digits: 2 (or desired value)

      • Maximum fractional digits: 2 (or desired value)

        

    • Select Save and Close.

13. Select Run Query and see the desired metric.

14. Select Done Editing to exit the step.