Dashboards & Visualizations

Displaying count as label in pie graph

anusuya_k
New Member

Hi,
I have a pie graph which shows slices based on the count in each category. On splunk interface, I can see the actual count on each slice using tooltip. But when I export to a pdf, tooltip option will not be available, so counts are not visible.

Is there any way to display count on pie chart slices as labels? I have tried a few suggestions seen in the forum like using layout sprite etc, but none of them worked.

Please let me know whether it is possible at all to do this in splunk, and if so how to do it.

Thanks

Tags (1)
0 Karma
1 Solution

Gilberto_Castil
Splunk Employee
Splunk Employee

You can alter the given label after the chart has been rendered. For example, if you had a search that produces a simple count using top:

 * earliest=-15m | top sourcetype

That may produce a pie chart like this one:

alt text

Understand that your label is derived from column 1 or the "sourcetype" field. After the table has been generated, modify column 1 to include the count.

 | eval sourcetype=sourcetype." count:".count

That will render something like this:

alt text

All together your search would look like this:

* earliest=-15m | top sourcetype | eval sourcetype=sourcetype." count:".count

gc

View solution in original post

Gilberto_Castil
Splunk Employee
Splunk Employee

You can alter the given label after the chart has been rendered. For example, if you had a search that produces a simple count using top:

 * earliest=-15m | top sourcetype

That may produce a pie chart like this one:

alt text

Understand that your label is derived from column 1 or the "sourcetype" field. After the table has been generated, modify column 1 to include the count.

 | eval sourcetype=sourcetype." count:".count

That will render something like this:

alt text

All together your search would look like this:

* earliest=-15m | top sourcetype | eval sourcetype=sourcetype." count:".count

gc

anusuya_k
New Member

your suggestion worked perfectly well. Thanks a ton.

0 Karma

clymbouris
Path Finder

I'm not sure if that's possible with the built-in pie graph but this sweet app might be what you're looking for: http://splunk-base.splunk.com/apps/56187/donut-charts

0 Karma
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!

Thanks for the Memories: .conf26 Took Learning to New Heights

Thank you, Splunk Community, for making .conf26 in Denver one for the books. From packed Splunk University ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Splunk Auto Ingestion Parallel Pipeline Scaling

Why this feature matters Many Splunk environments experience ingestion pressure long before the host is fully ...