I am having a hard time understanding how averages are done in dataview. I have looked at some posts in the forum but I can’t understand how they work.
I have an existing and working query that gets me the total MTTC of my tickets.
TABLE WITHOUT ID row.key AS Days, MTTC
WHERE contains(file.name,"INC") OR contains(file.name,"SCTASK") AND !contains(Closed, null) AND !contains(Created, null)
FLATTEN (Closed - Created).days AS MTTC
GROUP BY MTTC
FLATTEN length(rows.MTTC) as MTTC
What I need is to get the weekly average MTTC. Can someone help?