moving average and referring previous value

[Vijayt]

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

[Ahmedrahbi]

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.

[Julius_Loman · Accepted solution]

@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