5 Replies Latest reply: Nov 9, 2016 12:16 PM by popescu cosmina RSS

    Average of top n items/dimensions in a dataset

      Hi Guys,


      I am currently analysing month wise average of ticket closing time. However, I want to look at just the average closing time of top 100 closed tickets/first quartile every month.


      For example:


      ID           Open Time    Closing Time     Month

      1                  10                  15                   Jan

      2                  20                   30                  Jan

      3                  25                   30                  Jan


      Here, if I am interested in first 2 ids of Jan, average should be 7.5 (Closing time-open time).


      Can this be done on front end? I tried through set analysis but it didn't work.