topic Re: moving average and referring previous value in Dashboarding

Moving average and referring previous value in Dashboard

Vijayt — Mon, 01 Dec 2025 11:57:08 GMT

is there any option to calculate moving average [avg transformation? ]

and any option to compare with previous data points/aggregation values

for example i want to compare last 1 max memory is greater than current max memory

I have access only dataexplorer NOT DSQL

Re: moving average and referring previous value

Ahmedrahbi — Fri, 01 Aug 2025 20:13:22 GMT

Yes, there are multiple ways to achieve this, but I personally prefer this method:
After you pin the metric to the dashboard, click on it and you’ll see a panel on the left side where you can set a custom timeframe (for example, the last 5 minutes).
Once set, you can clone the tile without the fixed custom timeframe, and it will always show the latest 5-minute data dynamically.

Re: moving average and referring previous value

Julius_Loman — Fri, 01 Aug 2025 21:33:57 GMT

@Vijayt would :rollup transformation in metric selector do the moving average for you?

You have at least two options to compare:

use :timeshift transformation in metric selector (unfortunately, it's absolute only). You can also use metric expressions and subtract two metrics
use two tiles on a dashboard and set a custom time frame for one tile