Is there a way to compute a Cumulative Sum in QuestDB query?
For context - I am exposing QDB data via Grafana and need to compute the cumulative sum.
After I did some digging, it seem that it’s not supporter in QDB or in Grafana (I only found that InfluxDB have this).
So here is a Feature Request: https://github.com/questdb/questdb/issues/2995
Anyone else who wants that feature, please vote up in GitLab 👍 🙂
Please make these happen sooner. They are extremely useful!:)
02/16/2023, 12:02 PM
if we get support for analytical functions, then your cum sum would became just a SUM(x) OVER ()
02/16/2023, 12:24 PM
I have already upvoted all of these before : D (no surprise)
+ participated in some of the convos.
So then do you know if there is a realistic date when these would materialize?
It would make a big difference.
02/16/2023, 12:26 PM
I don’t know, but I will casually drop on the internal slack that this has been requested again
02/16/2023, 12:27 PM
Yes please - the community is way bigger now, so I am certain more people want it (based on my internet search). + Grafana does not offer it… which is a shame and many ppl use it to visualize. So the processing is left to Quest