hey
looking at your comments section you can try
| eval dateyearweek=strftime(_time,"%Y-%U") | stats sum(incident_duration) as Weekly_Inc_duration BY AppID dateyearweek
Depending of your country, you have 2 variations :
%U is replaced by the week number of the year (Sunday as the first day of the week) as a decimal number [00,53].
%V is replaced by the week number of the year (Monday as the first day of the week) as a decimal number [01,53]. If the week containing 1 January has four or more days in the new year, then it is considered week 1. Otherwise, it is the last week of the previous year, and the next week is week 1.
Let me know if this helps!
... View more