We have internal app that helped us look at metrics in realtime. Some of the metrics like moving average and week over week are pretty helpful. I was looking for support of such metrics on grafana but couldn’t find them. I did read up on grafana’s idea on relying on the backend DB to do it. In case of elastic search it does provide moving average. But I am unable to understand as to why that restriction. The way we look at , it is a function of data representation and not the data itself. So fitting it around the frontend made more sense.
Thanks @daniellee, I’ll work with the team in regards to the issue. Can you help me with one more query ?
I am looking for ability to join two metrics on client side. I do see that grafana supports showing two metrics on one table but the way it works is that it appends rows of one query with rows of another. It is very helpful to join metrics on a table. For example If we want to plot number of signups , orders by the app ( android vs iOS vs web) then its better to present in following fashion:
also time shift functionality moves the existing chart by x points, It is helpful to compare today’s metric with previous weeks metric. In that case the timeshift functionality does not help.