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

    Average of top n items/dimensions in a dataset

    Ankit Tripathi

      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.

       

      Thanks.