Skip to main content
Sumo Logic

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 type Cardinality threshold
Chart tab with a Single Value panel type 1 unique series
Chart tab with a Time Series or Categorical panel type 10 unique series
Time Series tab 50 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.

hint1.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.

hint2.png

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

hint3.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.

disable-query-tips.png