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!
| 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
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
and a few other combinations but none seemed to work.
Any help would be appreciated!