7 Replies Latest reply on Nov 11, 2016 7:04 PM by Yuriy Fal

    How to show percentage greater than a subset of population in a line chart

    Nicholas Nemirsky

      Hello,

       

      I am trying to create the following view in a line chart with Date for the x axis and percentage of values greater than another percentage value of that data set

       

      For example, below in July, 2016, I have 95% occurring 3 out of 10 times, which accounts for 30% of that data.  I want to create a line chart that shows for each month, what percentage of the data is above the percentage threshold.  This reflects on the line chart as being 30% for 7/1/16.

       

      The data as uploaded into tableau in the raw format below with a pivot table I created in excel to simplify the explanation.  How can I do the counts, then percentages of those in each category, then plot is as such in the line chart.  Any help is appreciated.  Thanks!

       

       

      DateValue
      1/1/201695%
      1/1/201690%
      1/1/201685%
      1/1/201695%
      1/1/201695%
      1/1/201695%
      1/1/201695%
      1/1/201685%
      1/1/201685%
      1/1/201685%
      4/1/201685%
      4/1/201685%
      4/1/201685%
      4/1/201685%
      4/1/201660%
      4/1/201660%
      4/1/201660%
      4/1/201660%
      4/1/201660%
      4/1/201695%
      7/1/201695%
      7/1/201695%
      7/1/201695%
      7/1/201680%
      7/1/201680%
      7/1/201680%
      7/1/201680%
      7/1/201690%
      7/1/201690%
      7/1/201690%

       

            

      DateValueCount of ValuePercent >= 70Percent >= 85%Percent >=95%
      1/1/201685%4100%100%50%
      1/1/201690%1100%100%50%
      1/1/201695%5100%100%50%
      4/1/201660%550%50%10%
      4/1/201685%450%50%10%
      4/1/201695%150%50%10%
      7/1/201680%4100%70%30%
      7/1/201690%3100%70%30%
      7/1/201695%3100%70%30%