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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...