Hello Grafana Community!
I would like to create a Grafana panel with our user database (PostgreSQL). This scene from HBO’s Silicon Valley already describes it perfectly.
But I can’t figure out how to get the “historical count” working.
My rough idea is this:
SELECT created as time, count(*) FROM user WHERE created BETWEEN "FIXED START DATE" AND created ORDER BY created ASC
But I encounter issues, that I have to add a GROUP BY clause, because of the aggregate function. Which seems legitimate. But how can I do an aggregation with the “history” of existing entities to the time of the graph position?
I would be thankful for every assistant advice!