1 Reply Latest reply on Nov 12, 2018 4:50 AM by Jim Dehner

    How to make a percentile function work as how its functionality in excel?

    sana.firdaus

      I have used  percentile function to calculate the 90th percentile and cross checked with excel function but results are not similar.

      is there any alternative formua which can be used  to get the same functionality in tableau ?

        • 1. Re: How to make a percentile function work as how its functionality in excel?
          Jim Dehner

          Good morning

          Percentile is a function that works on the filtered number of marks in the view - sounds a little techy but what it does is count the number of points in the view and then separates them into 2 groups - to create the 10%/90% by count - when returning a value it does an interpolation between the 2 values on either side of the boundary.

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.