I want to create a bar chart with these following search
eventtype="et_system_metrics" Stage=A* | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 | eval percentage = (count2/count1)*100
eventtype="et_system_metrics" Stage=D* | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 | eval percentage = (count2/count1)*100
eventtype="et_system_metrics" Stage=O* | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 | eval percentage = (count2/count1)*100
eventtype="et_system_metrics" Stage=R* | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 | eval percentage = (count2/count1)*100
eventtype="et_system_metrics" Stage=S* | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 | eval percentage = (count2/count1)*100
The only difference in these search is Stage - so it should display 5 bar with percentage
I am confused how to arrange these search 😞
If I display chart like
eventtype="et_system_metrics" | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 | eval percentage = (count2/count1)*100 | chart values(percentage) by Stage
I can't see anything.
How do I display bar chart with above search?
How does this work for you:
eventtype="et_system_metrics" | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 by Stage | eval percentage = (count2/count1)*100 | chart values(percentage) by Stage
How does this work for you:
eventtype="et_system_metrics" | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 by Stage | eval percentage = (count2/count1)*100 | chart values(percentage) by Stage
You should post a new question for this one with some more details.
How DO I set Min/Max value ?
I am using sideviews and following is not working
No genius here...but you can certainly find some at the Apple store.
You are genius 🙂
I used by Stage but with first count
Does this give you the table you are expecting:
eventtype="et_system_metrics" | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 by Stage
A list of each Stage and a count for each job status? If so, then you should be very close to getting what you want.