All Apps and Add-ons

collapsing threshold in donut chart

splunkdivya
Explorer

Hi Splunkers,

I have a use case where in I am plotting count against users with donut. Now, the issue is: for values < 99%, we get an "OTHER" slice. I need the complete dataset, no "other" slice. tried collapsing threshold with the visualisation, even limit=0 does not work for me. Any pointers would be highly appreciated.

Best,

0 Karma

chuckf
New Member

Adjust the formatting of the visualization in version 1.0.3 (or higher) which was recently uploaded to Splunkbase. For the “Use Min Percent” setting change it from Yes to No. This will disable the Min Percent setting and display all of the results from the search as slices in the Donut visualization. Depending on the data, this may result in a very noisy visualization.

Another method, which doesn't sound like it would be an option in this particular case but others may find useful, is to use the ‘top’ search function as a part of the original search. If your search is, for instance, "index=main | chart count(source) by source”, consider changing it to "index=main | chart count(source) by source|top limit=12 source”. The latter search will only display the top 12 results in the search and eliminate the OTHER slice from appearing. The limit setting must be at least 1 less than the amount of results that causes the OTHER slice to appear, so it may take some adjusting to get the OTHER slice not to appear. This will mean that you do not see the results of the lowest number of results from your search reflected in any way in the visualization, but will potentially be less noisy than eliminating the min percent setting.

Hope this helps.

0 Karma

splunker12er
Motivator

you can remove the "OTHER" from the results with "useother=f",

e,g.

| timechart span=1d sum(field_1) AS sum_field_1 by field_2 useother=f fixedrange=false

0 Karma
Get Updates on the Splunk Community!

Splunk Education - Fast Start Program!

Welcome to Splunk Education! Splunk training programs are designed to enable you to get started quickly and ...

Five Subtly Different Ways of Adding Manual Instrumentation in Java

You can find the code of this example on GitHub here. Please feel free to star the repository to keep in ...

New Splunk APM Enhancements Help Troubleshoot Your MySQL and NoSQL Databases Faster

Splunk Observability has two new enhancements to make it quicker and easier to troubleshoot slow or frequently ...