4 Replies Latest reply on Dec 28, 2018 1:40 AM by seif saleh

    Top 10% and Lowest 10% average

    seif saleh

      Hi,

       

      I have the below figures: 

      Duration
      3
      4
      7
      8
      9
      10
      3
      4
      7
      8
      9
      10
      3
      4
      7
      8
      9
      10

       

      I am trying to calculate the following:

       

      1. Average duration: I used avg(duration)
      2. The average of highest 10% values as a tooltip
      3. The average of lowest 10% values as a tooltip

       

      I am finding it hard to calculate points 2, 3.

       

      Any suggestions ?

       

      Thanks !