Skip to main content

Metric Aggregation Tips

When you run a metrics query that returns high cardinality results, the Metrics Explorer displays a tip for how to use an aggregation clause to produce more readable results. An aggregation tip is displayed for a query based on the cardinality of the query. It is presented when a query’s cardinality exceeds these thresholds:

Tab / Chart typeCardinality threshold
Chart tab with a Single Value panel type1 unique series
Chart tab with a Time Series or Categorical panel type10 unique series
Time Series tab50 unique time series

Aggregation tips are available in the Metrics Explorer, and in metrics queries in Dashboards.

View aggregation tips

The screenshot below shows the Time Series tab for a query that returns 270 time series. Note the tip below the query suggests grouping the data by the prometheus_replica dimension using the avg operator. You can ignore the tip and close the tip by clicking the x to the right. Or you can click Add operator to query to add the recommended operator and dimension to your query.

line-commented.png

If you click Add operator to query, the aggregation clause is added to your query. We don’t run the query automatically—press Enter, or click the run icon to execute the query.

line-commented.png

If you’re running multiple queries, a tip will be provided for each of the queries that exceeds a cardinality threshold.

line-commented.png

Disable tips

If you prefer not to see query tips, choose Disable Query Tips from the three-dot more options menu in the Metrics Explorer.

line-commented.png
Legal
Privacy Statement
Terms of Use

Copyright © 2023 by Sumo Logic, Inc.