https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399693#M26184 <P>Hi, here is a sample lookup file's table/csv:</P> <P>sample.csv</P> <PRE><CODE>Animal Color horse black horse Grey horse Orange horse Grey horse Grey </CODE></PRE> <P>How can I display ONLY the colors black vs. grey in a pie chart with their respective percentages? My below code only shows a single-colored pie chart and their count.</P> <PRE><CODE>|inputlookup sample.csv |chart count(eval(color = "black" )) as Noir count(eval(color = "grey")) as Gris </CODE></PRE> Tue, 25 Sep 2018 19:35:30 GMT russell120 2018-09-25T19:35:30Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399693#M26184 <P>Hi, here is a sample lookup file's table/csv:</P> <P>sample.csv</P> <PRE><CODE>Animal Color horse black horse Grey horse Orange horse Grey horse Grey </CODE></PRE> <P>How can I display ONLY the colors black vs. grey in a pie chart with their respective percentages? My below code only shows a single-colored pie chart and their count.</P> <PRE><CODE>|inputlookup sample.csv |chart count(eval(color = "black" )) as Noir count(eval(color = "grey")) as Gris </CODE></PRE> Tue, 25 Sep 2018 19:35:30 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399693#M26184 russell120 2018-09-25T19:35:30Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399694#M26185 <P>Hi @russell120 </P> <PRE><CODE>|inputlookup sample.csv |where Color in ("black","grey") |stats count by color </CODE></PRE> <P>If my answer helped pls upvote or accept as answer.</P> Tue, 25 Sep 2018 19:47:01 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399694#M26185 harishalipaka 2018-09-25T19:47:01Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399695#M26186 <P>@harishalipaka This allows a table to be shown where Color are either of those values, but when I select the Pie Char visulization button, there are no results. The empty grey pie chart says Numeric Data Required.</P> Tue, 25 Sep 2018 19:57:21 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399695#M26186 russell120 2018-09-25T19:57:21Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399696#M26187 <P>Nevermind! I added</P> <PRE><CODE>|stats count by Color </CODE></PRE> <P>to the end and it worked!</P> Tue, 25 Sep 2018 19:59:28 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-create-a-pie-chart-with-specific-field-values/m-p/399696#M26187 russell120 2018-09-25T19:59:28Z