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?




      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.