1 Reply Latest reply on Jun 14, 2013 9:10 AM by Shawn Wallwork

# somewhat complicated series to calculate and graph

I have a much larger table similar to below. I am not sure really how to describe it other than provide an example of what I am trying to graph.  I am having trouble with the calculations and not sure how hard this is to do in Tableau and looking for help...so here it goes:

Total Count of Blue in Jan was  77 (50+22)

Total Count of Blue in Feb was 50 (40+10)

Total percentage difference is  -35% (50-77)/77*100

What I want to show in a time series type graph:

For each name (in this case Gelato) Percentage Difference of Gelato's performance against the Total Blue sold so Feb data  point would be 15%  ( -20% - (-35%)) .  The twenty percent comes from Percentage difference on Blue Gelato's performance (40-50)/50*100=-20% and the -35% is the percentage difference of  all Blue from Feb to Jan.

###########TABLE

 YEAR-MONTH NAME Color Total Count 2012-Jan Gelato Blue 50 2012-Feb Gelato Blue 40 2012-Jan Gelato Red 45 2012-Feb Gelato Red 20 2012-Jan Ice Cream Blue 22 2012-Feb Ice Cream Blue 10 2012-Jan Ice Cream Red 89 2012-Feb Ice Cream Red 100
• ###### 1. Re: somewhat complicated series to calculate and graph

This probably went unanswered because you didn't include a package workbook. If you're still looking for an answer for this, post a packaged workbook so we can have something to work with.

--Shawn