Splunk Search

How to display one row table in a pie chart?

LearningGuy
Motivator

How to display one row table in a pie chart?
Thank you for your help.

index=test
---- Score calculation -----
| table Score1, Score2, Score3, Score4

Score1Score2Score3Score4
70506090


My expected Pie Chart:     

CloudGuy_0-1700070887201.png

 

Labels (3)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| transpose 0 column_name=score

View solution in original post

LearningGuy
Motivator

Hello,
Your suggestion worked. Thanks for your help. I accepted this as a solution
Although the value field was labeled as "row 1". I was able to rename it as "value" field
| rename "row 1" as value
Please let me know if this is a good approach..  Thanks


0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

That works although it makes little difference to the pie chart

ITWhisperer
SplunkTrust
SplunkTrust
| transpose 0 column_name=score
Get Updates on the Splunk Community!

Celebrating Fast Lane: 2025 Authorized Learning Partner of the Year

At .conf25, Splunk proudly recognized Fast Lane as the 2025 Authorized Learning Partner of the Year. This ...

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...