Dashboards & Visualizations

How to create a pie chart with specific field values?

russell120
Communicator

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
0 Karma
1 Solution

harishalipaka
Motivator

Hi @russell120

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

If my answer helped pls upvote or accept as answer.

Thanks
Harish

View solution in original post

0 Karma

harishalipaka
Motivator

Hi @russell120

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

If my answer helped pls upvote or accept as answer.

Thanks
Harish
0 Karma

russell120
Communicator

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

0 Karma

russell120
Communicator

Nevermind! I added

|stats count by Color

to the end and it worked!

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...