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 🙂
Hi shariinPH;
from the docs http://docs.splunk.com/Documentation/Splunk/6.1.4/Viz/Datastructurerequirementsforvisualizations#Pie...
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
Hi shariinPH;
from the docs http://docs.splunk.com/Documentation/Splunk/6.1.4/Viz/Datastructurerequirementsforvisualizations#Pie...
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
Thanks @Mus. It works! 😄
| transpose is what I needed