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

    Calculate Average of Latest Week


      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



      any help would be appreciated