3 Replies Latest reply on Jul 21, 2016 1:08 PM by Derrick Austin

    How to get Date for corresponding to '40%' of maximum value?

    Cerberus DA

      Hi,

       

      I am new to Tableau.

       

      I have a dataset in the following format:

       

        

      DatePubImpression
      12/1/13Abc10
      10/1/14Abc20
      11/1/14Abc50
      12/1/14Abc35
      1/1/15Abc12
      12/1/13xyz20
      10/1/14xyz40
      11/1/14xyz80
      12/1/14xyz12
      1/1/15xyz3
      12/1/13pqr35
      10/1/14pqr55
      11/1/14pqr70
      12/1/14pqr25
      1/1/15pqr10

       

       

      If you notice that the impressions for each 'Pub' reach a max and then go down.

      I know how to calculate the max impression for each Pub. I want to know the date when impressions hit 40% of the max impressions mark on their way down. Note that the above data is just for example. The actual data is far more complex but follows a similar pattern.

      Please comment if you need further info to answer the question. Any help is appreciated.

       

      Thanks.