9 Replies Latest reply on Aug 10, 2018 10:28 AM by Shinichiro Murakami

    Rank_Percentile for Weighted Avg. - Multiple Months

    Farbod Azizi

      Hi Everyone,

       

      I currently use Rank_Percentile to rank each sales person each month by a weighted value calculation (weighted value calculated in a sql query). I want to add a filter where managers could select multiple months and see how each sales person is ranked for the selected months.

       

      Does Rank_Percentile still work correctly if I was to select multiple months for that "weighted vale" calculation?

       

      I.e.

       

      Sales PersonJanuary Rank_PercentileFebruary Rank_PercentileMarch Rank_Percentile
      John Doe0.80.50.7

       

      Hope this makes sense. Please let me know if I should clarify any further.

       

      Thanks,

      Farbod