https://community.splunk.com/t5/Dashboards-Visualizations/What-is-the-best-way-to-calculate-the-percentage-of-a-query-and/m-p/419213#M27621 <P>If the events are in the same index you could simply add an OR in the search string and then extract the values you need with a rex extraction; something like:</P> <PRE><CODE>search "upload succesful" OR "[ERROR]"| rex "\&gt; (?&lt;result&gt;.*)" | top result </CODE></PRE> Mon, 08 Oct 2018 08:37:42 GMT jlelli 2018-10-08T08:37:42Z https://community.splunk.com/t5/Dashboards-Visualizations/What-is-the-best-way-to-calculate-the-percentage-of-a-query-and/m-p/419212#M27620 <P>What is the best way to calculate the percentage and transform it into a pie chart or two single value charts side by side :</P> <PRE><CODE> Condition for success =&gt; message=Upload successful Condition for error = &gt; [ERROR] </CODE></PRE> <P>Please help I am not able to figure out the correct way?<BR /> What I used to generate a single chart is very wrong I have to append for queries together to generate a result. </P> Mon, 08 Oct 2018 05:58:41 GMT https://community.splunk.com/t5/Dashboards-Visualizations/What-is-the-best-way-to-calculate-the-percentage-of-a-query-and/m-p/419212#M27620 Navitas28 2018-10-08T05:58:41Z https://community.splunk.com/t5/Dashboards-Visualizations/What-is-the-best-way-to-calculate-the-percentage-of-a-query-and/m-p/419213#M27621 <P>If the events are in the same index you could simply add an OR in the search string and then extract the values you need with a rex extraction; something like:</P> <PRE><CODE>search "upload succesful" OR "[ERROR]"| rex "\&gt; (?&lt;result&gt;.*)" | top result </CODE></PRE> Mon, 08 Oct 2018 08:37:42 GMT https://community.splunk.com/t5/Dashboards-Visualizations/What-is-the-best-way-to-calculate-the-percentage-of-a-query-and/m-p/419213#M27621 jlelli 2018-10-08T08:37:42Z https://community.splunk.com/t5/Dashboards-Visualizations/What-is-the-best-way-to-calculate-the-percentage-of-a-query-and/m-p/419214#M27622 <P>hi @Navitas28 </P> <P>Did the answer below solve your problem? If so, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help ya. Thanks for posting!</P> Mon, 08 Oct 2018 19:02:46 GMT https://community.splunk.com/t5/Dashboards-Visualizations/What-is-the-best-way-to-calculate-the-percentage-of-a-query-and/m-p/419214#M27622 mstjohn_splunk 2018-10-08T19:02:46Z