Show the running total day by day
On the dashboard a «revenue running total over the period» panel shows how much has accumulated from the start of the period to each day. Classic cumulative sum. For every day compute the running total of revenue from the start of the period up to and including that day. Sort by day.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| d | total |
|---|---|
| 2024-01-01 | 100.00 |
| 2024-01-02 | 220.00 |
| 2024-01-03 | 330.00 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in