1 Reply Latest reply on Apr 4, 2017 11:27 AM by diego.medrano

    How to find the top 25% percentile, and take the minimum value from it

    Samim Riaz

      I am trying to rank my data into percentile and take the minimum from top 25 percentile. However also want to make the calculation fixed at certain level

       

      So a sample data is below.

         

      Weeks  Customer_joinedCustomer_activated
      1104
      22012
      32015
      44020

      I am thinking of using a calculated field with Rank_percentile and Exclude. Any suggestion?

       

      Thanks