Good night people.
I am studying SQL and training in graphics generation using MetaBase.
In one exercise you are asked to generate a billing graph per day, using accumulated sum. How could I do it? I’m only managing to generate a “normal” sum.
I would like a graph with increasing revenue as follows (figure)
I’m just getting this type of graph
Please post “Diagnostic Info” from Admin > Troubleshooting, and which database you are querying.
If you are doing your own manual SQL, then you need to do accumulated sum in the query.
Metabase has a built-in function that will do it via the GUI - called “Cumulative sum of …”