« first day (1281 days earlier)      last day (868 days later) » 

5:50 AM
0
Q: How to group and get average time using query

kenneth kennethi want to create a graph for total handle time per user to track everyday works but i can't achieve the result that i want. im just a newbie in query. this is my query =query({O49:O72,ArrayFormula(EOMONTH(N49:N72,0)),P49:P72},"Select Col2, AVERAGE(Col3) group by Col2 format Col2'MM-DD-YYYY'"...

 

« first day (1281 days earlier)      last day (868 days later) »