3 Replies Latest reply: Jul 24, 2018 8:20 AM by Bala Bhaskar RSS

    Displaying top 10% and bottom 10 %in chart

    V Kumar

      Hi All,

       

      i have a requirement to display top 10 % and Bottom 10% based on KM/lit.

       

      i have a fields ID and KM/Lit.

      KM/Lit=(sum(Diff_distance_drive)/sum(Diff_total_fuel_consumption)

      =Aggr(if(rank(sum(Diff_distance_drive)/sum(Diff_total_fuel_consumption))<=,VIN,NULL()),VIN)

      i have used above expression and able to display top 10 values but i want to display top 10%

       

      e.g: i have total 60 id are present. here i need to calculate 60*(10/100)=6 6 is top 10% values.

      Please help me

      IDKM/Lit
      1214.11
      1234.72
      1243.30
      1253.06
      1263.08
      1273.75
      1283.88
      1293.91
      1304.29
      13113.42
      1324.10
      1332.83
      1343.91
      1353.91
      1363.64

       

      Thanks in advance.