Skip to main content
Sumo Logic

Filter Time Series

Filter your time series in queries to refine your visualizations to just the data you want to see.

When you want to filter, you can use a mathematical expression in your query to combine aggregate functions, comparison and boolean operators, and numerical values to help limit your search to the data you need.

The following metrics operators can filter your time series:

  • topk -  take the top X time series

  • bottomk - take the bottom X  time series

  • filter - take a specific math function of a time series (max, min, avg, sum)

And with these filters you can reduce down your time series. For example:

  • metric=cpu | filter min > 20 and max < 50

  • dep=prod metric=cpu_system | topk (10, max /avg * 2)

This helps you focus on areas of interest in your metrics data, and remove the additional “noise” of less important data. For example, if you want to see just the cpu metrics with an average over the time range queried is greater than 95:

metric=cpu | filter avg > 95

Or if you want to take the top three max values for your RequestCount metric:

namespace=AWS/ApplicationELB  metric=RequestCount LoadBalancer=* Region=* _source=* _collector=* | avg by LoadBalancer,Region | topk (3,max)


If you want the top 3 times of the max of the time series divided by double the average to see spikes in RequestCount:

namespace=AWS/ApplicationELB  metric=RequestCount LoadBalancer=* Region=* _source=* _collector=* | avg by LoadBalancer,Region | topk (3,max/avg*2)


_sourceCategory=mysources | topk(5, max(max, min(min, max)))

The filters are in red, the math functions are in blue.