2 Replies Latest reply on Dec 7, 2017 11:08 PM by rohan.thareja

    Calculate Average of Latest Week

    rohan.thareja

      Hi Everyone,

       

      Im have to calculate average of incidents for the latest week. I have extracted week from each date and arranged in desc order. Data would start from week 0 and then subsequent week 1 , week 2 and hence forth. I have colour marked the weeks red for week 0, green -->weekCapture-2.PNG

       

      I m trying to calculate average for each clock  assignment group for week 0.

      tried below but somethings amiss

       

      Pic-2.PNG

      any help would be appreciated