3 Replies Latest reply on Nov 7, 2018 8:51 PM by Justin Pulley

    PERCENTILE function gone?

    Justin Pulley

      In a previous version of Tableau desktop (2018.1.4 I think) I created a workbook using PERCENTILE as follows


      PERCENTILE({FIXED [Short Id] : [Total Duration] },.9)


      in 2018.3 This is erroring as an unknown function.  What can I do to replicate this as it is used in another calculation.


      IF [TP90] <= [UPG Goal]

          THEN "Met"

      ELSE "Exceeded"


        • 1. Re: PERCENTILE function gone?
          Don Wise

          Hi Justin,

          Not sure what you're connecting to in terms of data source, but my experience has been, if you're connecting to certain types of DB's the PERCENTILE function is not available unless you perform an Extract first.  Then it will be available to you.  Hope that helps?  Thx, Don

          • 2. Re: PERCENTILE function gone?
            Jim Dehner

            Don is correct - Percentile and some other functions need to look at data at the record level - if the data is live and coming from some d/bs those functions will not be available

            so -if you can try extracting the data - the record level calculations will then be available



            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.

            • 3. Re: PERCENTILE function gone?
              Justin Pulley



              Yep forgot when I replaced the data source to mark the new one as an extract.  Thanks.