Forum Discussion
Calculating rate of change in Log Analytics
CliveWatson you are a scholar and a gent. That would appear to do the trick. I'll adapt as necessary but thank you
CliveWatson Thanks for the reply. I have looked at that. It's not the number of new entries per minute I am trying to ascertain, but the change in the sum of all previous entries per minute, if that makes sense.
ie in the above query, you'll see system mode cpu usage for computer aks-agentpool-31816283-2 goes from 264552.21 to 264560.83 in the minute, so i want the difference between those 2 on an on-going basis. In fact, I actually want it for all modes but one step at a time.
Peter Hall Did you find out prometheus "rate" equivalent function in kusto
santhoshparepu For anyone still looking for a Prometheus equivalent to rate of change the link below defines a Kusto User Defined Function to calculate rate of change from a Prometheus style counter which can only go up, unless reset. https://docs.microsoft.com/en-us/azure/data-explorer/kusto/functions-library/series-rate-fl?tabs=adhoc
