14 Replies Latest reply on Aug 20, 2018 7:26 AM by Rick Byrd

# Create cumulative view graph

I need to create a cumulative view bar graph of the pageviews from our blog posts using the Contain function.  I would use the url - /blog/

The columns are Month and the rows are Sum(Pageviews).

I can get the bar graph to show the total pageviews for each month(see below) and now I need to know how to create the cumulative month over month calculation.

Any ideas for this would be appreciated.

Rick

• ###### 1. Re: Create cumulative view graph

Hi Rick,

There's a table calculation for a running total that will give you a cumulative chart, if you right click on the pill you'll see this option.

1 of 1 people found this helpful
• ###### 2. Re: Create cumulative view graph

Chris,

Thanks so much.  I love this forum as a newbie I am learning so much about Tableau.

Rick

• ###### 3. Re: Create cumulative view graph

Chris.

Is it also possible to create a second label showing the cumulative month over month % difference?  I was able to create a second row and calculate the month over month difference but not the cumulative difference.

Rick

• ###### 4. Re: Create cumulative view graph

Hi Rick,

If you click 'edit table calculation' you get the option too add a secondary table calculation, you should be able to add a difference calculation on top of the running total.

• ###### 5. Re: Create cumulative view graph

Chris,

Thanks for this.  I tried this and it only partially worked.  See below.  I added the secondary dimension but instead of adding the difference on top of the running total it changed the chart to only show the difference and added the numbers in brackets.  Any thoughts on what I did wrong?

• ###### 6. Re: Create cumulative view graph

Nice post...

• ###### 7. Re: Create cumulative view graph

Hi Rick,

The numbers in brackets are the calculation assistance to show what is being factored in by the table calc.

Are you looking for the chart to be the running total and the numbers the difference?

If you do then you need to use a separate measure for the label with the secondary table calculation, which you can do by dragging the pageviews pill on to the label then doing the table calculation on that.

• ###### 8. Re: Create cumulative view graph

Chris,

Sorry to be dense about this but this is what I get below.  I think I followed your directions.  I got the correct information in both charts.  Is it possible to just show 1 chart with the numbers from the bottom chart added into the top chart?

• ###### 9. Re: Create cumulative view graph

You should get what you're after if you drag the difference pill from the top to labels as below. If not is it data you can upload a packaged workbook of?

• ###### 10. Re: Create cumulative view graph

This is what I get.  I'm sure I'm still missing something.  The data is from Google Analytics.  I connect through the API.  I do appreciate your patience trying to help.

• ###### 11. Re: Create cumulative view graph

No problem.

I realised it's probably easier for me to share an example, so I've mocked up the attached with some random numbers that should give you what you need.

• ###### 12. Re: Create cumulative view graph

I couldn't load it.  I'm using version 10.4.

• ###### 13. Re: Create cumulative view graph

Here you go - this should work!

• ###### 14. Re: Create cumulative view graph

Chris,

Thanks!  That really helped!

Rick