topic How to use two different fields to create a pie chart? in Splunk Search

How to use two different fields to create a pie chart?

shariinPH — Thu, 16 Oct 2014 08:30:15 GMT

Hi Splukers,

My problem here is that i have a search :

index=myindexname sourcetype=mysourcetype |stats latest(field1) as postedpayments latest(field2) as exceptions |eval result=round(expected-actual)

What i want to do is that i want to show in the pie chart the value of posted payments and the value of the exceptions

Please help us with our problem

Thanks 🙂

Re: How to use two different fields to create a pie chart?

MuS — Thu, 16 Oct 2014 09:29:46 GMT

Hi shariinPH;

from the docs http://docs.splunk.com/Documentation/Splunk/6.1.4/Viz/Datastructurerequirementsforvisualizations#Pie_charts

Pie charts are one dimensional and only support a single series. They work off of tables with just two columns, where the first column contains the labels for each slice of the pie, and the second column contains numerical values that correspond to each label, determining the relative size of each slice. If the table generated by the search contains additional columns, those extra columns have no meaning in the terms of the pie chart and are ignored.

This means your search will not work this way. But there are some ways you can achieve the target; try this run everywhere command:

index=_internal OR index=_audit | stats count(buckets) AS buckets sum(kb) AS sum | transpose

or something like this

index=_internal OR index=_audit | eval type=case(isnotnull(kb), "kb", isnotnull(buckets), "buckets") | stats count by type

adapted to your provide search string, something like this should work:

index=myindexname sourcetype=mysourcetype | stats latest(field1) as postedpayments latest(field2) as exceptions | transpose

hope this helps to get you started ...

cheers, MuS

Re: How to use two different fields to create a pie chart?

shariinPH — Thu, 16 Oct 2014 09:56:05 GMT

Thanks @Mus. It works! 😄

Re: How to use two different fields to create a pie chart?

demodav — Thu, 03 Dec 2015 19:37:30 GMT

| transpose is what I needed