Hello,
I am looking to create a Clustered Bar Chart that aggregates monthly numbers from daily values.
To do this in Excel, do the following:
Create a cumulative change column based on daily changes,
Compute the end of month to end of month change
Create a Clustered Bar Chart that shows the changes by month.
In Tableau, I can:
Create a cumulative change using formulas,
Chart a cumulative change using the daily changes.
It's when I get to the Bar Chart that I am struggling with.
Anyone have experience doing these types of charts? These are very standard in industries such as health science and finance.
Thank you!
Would also love the ability to create a table, with the monthly, or quarterly cumulative change values as well!
Any thoughts would be appreciated. Thank you!