2 Replies Latest reply on Jan 4, 2017 12:58 AM by Chandra Bhaskar

    Average of top 5 entries by dimemsion

    Shubhangi Agarwal

      Hi ,

       

      I have following data :

       

      For selected time stamp ,I want to calculate following things :

       

      1.       For particular day , find top 5 entries and take average of it . Like this calculate average for every day .

      2.       For particular week , Take top 5 entries of days and take average. Like this calculate average for every week.

      Ta   Take Average of weeks

       

       

      Average Utilization

       

      Time_Stamp_EndtotalMemoryUsed_max
      11/4/14 2:00 AM55
      11/4/14 4:00 AM65
      11/4/14 6:00 AM34
      11/4/14 8:00 AM12
      11/4/14 10:00 AM34
      11/4/14 12:00 PM56
      11/4/14 2:00 PM78
      11/4/14 4:00 PM98
      11/4/14 6:00 PM12
      11/4/14 8:00 PM12
      11/4/14 10:00 PM11
      11/4/14 12:00 AM10
      11/5/14 2:00 AM34
      11/5/14 4:00 AM54
      11/5/14 6:00 AM23
      11/5/14 8:00 AM76
      11/5/14 10:00 AM43
      11/5/14 12:00 PM65
      11/5/14 2:00 PM43
      11/5/14 4:00 PM78
      11/5/14 6:00 PM23
      11/5/14 8:00 PM45
      11/5/14 10:00 PM88
      11/5/14 12:00 AM65

        

      Please let me know ,if you have any solutions .