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.
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!