https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379555#M24824 <P>Hi @umsundar2015, </P> <P>Glad to help you. Can you please accept the answer to help community.</P> <P>Thanks <BR /> Happy Splunking</P> Mon, 11 Jun 2018 09:49:09 GMT kamlesh_vaghela 2018-06-11T09:49:09Z https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379551#M24820 <P>Hi ,<BR /> I have values like </P> <P>Failure Ignored Partial Success<BR /> 0 803 23 0<BR /> 24 0 0 0<BR /> 192 1 0 0<BR /> 23 6 21 45<BR /><BR /> 3 2 4 31<BR /> 5 89 4 85</P> <P>My requirement is to create a pie chart with the above values ( i mean with each column total count).These total columns should be<BR /><BR /> Show breakdown by Success/ Failure / Partial Success / Ignored. Show a pie chart for the week </P> <P>Can anyone help me .</P> Mon, 11 Jun 2018 08:18:25 GMT https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379551#M24820 umsundar2015 2018-06-11T08:18:25Z https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379552#M24821 <P>Hi @umsundar2015, </P> <P>Can you please try following?</P> <PRE><CODE>YOUR_SEARCH | stats sum(Failure) as Failure sum(Ignored) as Ignored sum(Partial) as Partial sum(Success) as Success | transpose </CODE></PRE> Mon, 11 Jun 2018 08:30:42 GMT https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379552#M24821 kamlesh_vaghela 2018-06-11T08:30:42Z https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379553#M24822 <P>@umsundar2015 what does each row represent? Also what is your current query for above table? Do you want to show each row also as pie?</P> Mon, 11 Jun 2018 09:14:39 GMT https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379553#M24822 niketn 2018-06-11T09:14:39Z https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379554#M24823 <P>oh yes . It works .</P> <P>Thank you ,<BR /> Kamalesh.</P> Mon, 11 Jun 2018 09:19:16 GMT https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379554#M24823 umsundar2015 2018-06-11T09:19:16Z https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379555#M24824 <P>Hi @umsundar2015, </P> <P>Glad to help you. Can you please accept the answer to help community.</P> <P>Thanks <BR /> Happy Splunking</P> Mon, 11 Jun 2018 09:49:09 GMT https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379555#M24824 kamlesh_vaghela 2018-06-11T09:49:09Z https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379556#M24825 <P>Hi, <BR /> Can you please help me to create a drill down for the above piechart </P> <P>When i select anyone of the above values like (Success,Failure,Ignored,Partial) ,I have the row value as Name which has machine name as its values.</P> <P>My search is ,<BR /> index=macqw2|fillnull|search name="Saqpedc102" |eventstats sum(Current_Failure) as Failure,sum(Current_Ignored) as Ignored,sum(Current_Partial) as Partial,sum(Current_Success) as Success |transpose|Rename "column" as Delta|search Delta="Ignored"|table Site Partial Success Failure Ignored</P> <P>I am getting error for this when i click th pie chart .Please help me with the search</P> Tue, 29 Sep 2020 19:58:20 GMT https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379556#M24825 umsundar2015 2020-09-29T19:58:20Z https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379557#M24826 <P>Hi, <BR /> Can you please help me to create a drill down for the above piechart</P> <P>When i select anyone of the above values like (Success,Failure,Ignored,Partial) ,I have the row value as Name which has machine name as its values.</P> <P>My search is ,<BR /> index=macqw2|fillnull|search name="Saqpedc102" |eventstats sum(Current_Failure) as Failure,sum(Current_Ignored) as Ignored,sum(Current_Partial) as Partial,sum(Current_Success) as Success |transpose|Rename "column" as Delta|search Delta="Ignored"|table Site Partial Success Failure Ignored</P> <P>I am getting error for this when i click th pie chart .Please help me with the search</P> Tue, 29 Sep 2020 19:58:23 GMT https://community.splunk.com/t5/Dashboards-Visualizations/how-to-create-a-pie-chart-with-different-sum-values/m-p/379557#M24826 umsundar2015 2020-09-29T19:58:23Z