I am trying to use calculated fields in QuickSight but as yet I’ve been unable to get the desired outcome
I have a line chart that shows me day by day sales comparing the last 3 months with each month as a separate line on the line graph
This is the field well configuration
x-axis transaction_date_day_extract: extract("DD", {transaction_date})
colour transaction_date_month_trunc: truncDate("MM", {transaction_date})
value transaction_amount (sum)
What I’m trying to achieve is the same visual (a line per year) but with a running total for the year with the x-axis showing the month number (1-12).
Ideally the field wells would be as follows
x-axis: Month Number 1-12
colour: Year
value: Running Total of Sales
Any advice would be appreciated