How to create a pie chart with specific field values?

[russell120]

Hi, here is a sample lookup file's table/csv:

sample.csv

Animal  Color
horse    black
horse    Grey
horse    Orange
horse    Grey
horse    Grey

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.

|inputlookup sample.csv
|chart
   count(eval(color = "black" )) as Noir
   count(eval(color = "grey")) as Gris

[harishalipaka · Accepted solution]

Hi @russell120

|inputlookup sample.csv |where Color in ("black","grey") |stats count by color

If my answer helped pls upvote or accept as answer.

[russell120]

@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.

[russell120]

Nevermind! I added

|stats count by Color

to the end and it worked!