SOURCE CODE | eventstats count(eval(errorCount=0)) AS passed, count(shortVIN) AS total | timechart span=1w@w0 eval((passed/total)*100) AS percentPassed
I get a message saying "expression has no fields" on the timechart. I am unsure which expression to use to display week 1's percentage, then week 2's percentage, and so on.
Any help is appreciated
I think this should work for you
| timechart span=1w@w0 count(eval(errorCount=0)) AS passed count(shortVIN) AS total
| eval PercentPassed=round(passed/total*100,2)You count the weekly values in the timechart command and then calculate the percentage after the timechart is done.