Hi,
I am using the below query to timechart the values of offers (STATUS=ACCEPTED) from midnight, of the current day, and compare them to lastweek. I had found this query on these forums, plugged it in and it works beautifully!
index="offers" STATUS="ACCEPTED" earliest=-7d@d
| eval StartTime=relative_time(now(), "@d")
| eval Series=case(
_time >=StartTime, "today",
_time <= relative_time(now(), "-6d@d"), "LastWk")
| timechart span=5m count by Series
| eval Time = strftime(_time, "%H:%M")
| chart sum(LastWk) as LastWeek, sum(today) as Today by Time
| eval Today=if(Today==0, "", Today)
My problem is I am trying to insert the below "eval Percent..." so I can compare "Percent" today vs lastweek, in the above "Series".
count(STATUS) AS total, count(eval(STATUS="ACCEPTED")) AS Accepted
eval Percent=((Accepted/total)*100)
I tried timewrap, but while that is nice, it is a super slow process and only compares a 24h "moving window"
I tried doing things like:
| timechart span=5m count(STATUS) AS total, count(eval(STATUS="ACCEPTED")) AS Accepted by Series
|eval Percent=((Accepted/total)*100)
and a few other combinations but none seemed to work.
Any help would be appreciated!
... View more