I need to create a table which will display
workweek as rows
and subarea as column, meanwhile the data inside will display the passing percentage for each subarea for every workweek.
i tried
*|stats count(eval(status="Failed")) AS fail,count(eval(status="Passed")) AS pass by workweek|eval passPercentage=if(pass+fail== 0, "-",round(pass/(pass+fail)*100,2))|fields workweek,passPercentage
This will only calculate for overall passPercentage for each workweek, but i want it to be done with each subarea of each workweek...
my sample output will be like this
subArea1 subArea2 subArea3...
workweek1 12 32 88
workweek2 96 45 12
workweek3 23 78 43
workweek4 37 79 98
Try this
yoursearchhere
| stats count(eval(status="Failed")) as fail, count(eval(status="Passed")) as pass by workweek subArea
| eval passPercentage=if(pass+fail== 0, "-",round(pass/(pass+fail)*100,2))
| xyseries workweek subArea passPercentage