bar chart with five search

[jangid]

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?

[sdaniels · Accepted solution]

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

[sdaniels]

You should post a new question for this one with some more details.

[jangid]

How DO I set Min/Max value ?

I am using sideviews and following is not working

[sdaniels]

No genius here...but you can certainly find some at the Apple store.

[jangid]

You are genius 🙂
I used by Stage but with first count

[sdaniels]

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.