This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
Hi there.
That’s something you must do in your query.
For instance, in PostgreSQL this is typically done with window functions.
An example:
This adds accumulating sums to your query, besides many other possibilities. You can then plot this column in your visualizations.
1 Like
Exactly. A simple example, assuming you use Postgres and are summing a sales
value:
SELECT
date_trunc('month', date_of_sale) "month",
sum(sales),
sum(sales) OVER (ORDER BY date_of_sale ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
FROM sales_table
GROUP BY 1
1 Like