I am trying to find the average time duration in hh:mm from the data in one column. Below is the search query which gives me data as below and I want the average time duration in hh:mm like average time duration of a column is 01:22 or whatever the value is. I tried looking for the same articles but nothing seem to work. Any help would be greatly appreciated. Thank you search month="Apr,2021" | stats count by "TotalTimeTaken (hh:MM)" | "TotalTimeTaken (hh:MM)" 00:24 01:44 02:23 00:54
... View more