Hi 👋 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 👍 🙂

I believe the standard way to do this with SQL is via window/analytical functions. We have a few open issues requesting those already, I will link yours there, but maybe you want to upvote https://github.com/questdb/questdb/issues/1351, https://github.com/questdb/questdb/issues/258, https://github.com/questdb/questdb/issues/1268

Please make these happen sooner. They are extremely useful!:)

if we get support for analytical functions, then your cum sum would became just a SUM(x) OVER ()

I have already upvoted all of these before : D (no surprise)

I don’t know, but I will casually drop on the internal slack that this has been requested again

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