https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105700#M27419 <P>You should post a new question for this one with some more details.</P> Mon, 29 Oct 2012 16:25:25 GMT sdaniels 2012-10-29T16:25:25Z https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105694#M27413 <P>I want to create a bar chart with these following search </P> <PRE><CODE>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 </CODE></PRE> <P>The only difference in these search is Stage - so it should display 5 bar with percentage</P> <P>I am confused how to arrange these search <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P> <P>If I display chart like </P> <PRE><CODE>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 </CODE></PRE> <P>I can't see anything.</P> <P>How do I display bar chart with above search?</P> Mon, 29 Oct 2012 15:51:54 GMT https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105694#M27413 jangid 2012-10-29T15:51:54Z https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105695#M27414 <P>How does this work for you:</P> <PRE><CODE>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 </CODE></PRE> Mon, 29 Oct 2012 16:02:19 GMT https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105695#M27414 sdaniels 2012-10-29T16:02:19Z https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105696#M27415 <P>Does this give you the table you are expecting:</P> <P>eventtype="et_system_metrics" | stats count(eval(JOBSTATUS="FINISHED")) as count1, count(eval(JOBSTATUS="PENDING")) as count2 by Stage </P> <P>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.</P> Mon, 28 Sep 2020 12:42:28 GMT https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105696#M27415 sdaniels 2020-09-28T12:42:28Z https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105697#M27416 <P>You are genius <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /> I used by Stage but with first count</P> Mon, 29 Oct 2012 16:12:15 GMT https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105697#M27416 jangid 2012-10-29T16:12:15Z https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105698#M27417 <P>No genius here...but you can certainly find some at the Apple store.</P> Mon, 29 Oct 2012 16:13:22 GMT https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105698#M27417 sdaniels 2012-10-29T16:13:22Z https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105699#M27418 <P>How DO I set Min/Max value ?</P> <P>I am using sideviews and following is not working</P> <P><OBJECT><PARAM name="charting.axisX.minimumNumber" />0<BR /> <PARAM name="charting.axisX.maximumNumber" />100</OBJECT></P> Mon, 29 Oct 2012 16:23:44 GMT https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105699#M27418 jangid 2012-10-29T16:23:44Z https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105700#M27419 <P>You should post a new question for this one with some more details.</P> Mon, 29 Oct 2012 16:25:25 GMT https://community.splunk.com/t5/Splunk-Search/bar-chart-with-five-search/m-p/105700#M27419 sdaniels 2012-10-29T16:25:25Z