Beast Mode for Calculating Yesterday, WTD, MTD, YTD
I am trying to create a PostgreSQL dataflow that will create a cumulative row column for my dataset to show "Yesterday," "Week-to-Date," "Month-to-Date," and "Year-to-Date."
For example, please see what I would like to accomplish below:
How would I go about creating a Cumulative Sum (WTD, MTD, YTD) row that will include all of the data that I'm looking for?
Thanks in advance.