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!