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

    somewhat complicated series to calculate and graph

    esc esc

      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-MONTHNAMEColorTotal Count
      2012-JanGelatoBlue50
      2012-FebGelatoBlue40
      2012-JanGelatoRed45
      2012-FebGelatoRed20
      2012-JanIce CreamBlue22
      2012-FebIce CreamBlue10
      2012-JanIce CreamRed89
      2012-FebIce CreamRed100