index=XYZ trunkgroup| stats count(_raw) as Total_Calls, count(eval(Sip_Resp=="200")) as Completed_Calls by OTG
| search Total_Calls>500 | eval Completion_Percentage= (Completed_Calls/Total_Calls * 100)|eval Completion_Percentage=round(Completion_Percentage,2)
Hello,
I have this simple query that provides total amount of calls, how many were completed, and the completion percentage.
I would like to add to this query where I compare it to the previous day at the same hour.
I would like this query to be dynamic where it is always comparing the previous day's hour.
What can I append to this search query that will show me the data yesterday at the same hour?
Any help would be greatly appreciated!
... View more