topic Re: min function on timeseries in Dashboarding

Minimum function on timeseries

MartinKulov — Tue, 13 May 2025 07:10:30 GMT

Is there a way to replace values on a timeseries metric using the min aggregation?

So lets say we have example data like (5,15,50,20,9) and we want to apply min(10) and the timeseries will be converted to (5, 10, 10, 10, 9).

Kind regards

Re: min function on timeseries

marco_irmer — Tue, 25 Mar 2025 11:16:08 GMT

You can do this with by using an iterative expression within an if statement.

data record(data = array(5,15,50,20,9)) | fieldsAdd newData = if(data[]<10, 10, else: data[]) // iterate through array elements and replace anything less than 10 with value 10. Else, keep current value.

Re: min function on timeseries

MartinKulov — Tue, 25 Mar 2025 13:51:42 GMT

I am sorry, I was referring to Data Explorer and Classical Metric expressions, not DQL.

Any idea how to implement this in Data Explorer?

Re: min function on timeseries

Julius_Loman — Wed, 26 Mar 2025 09:58:51 GMT

@MartinKulov Sure there is a solution.
You need to use :partition , apply the :filter and then substitute it using the :default transformation.

See an example in the playground tenant.