Pie Chart is not showing smaller values

[harshal_chakran]

Hi ,
I have a CSV file, whose visualization I want to see in the form of Pie-Chart.
But on display, one of the parameter is not shown. I am guessing the Pie-chart is hiding it because of its small value.
Below is my CSV file:

PARAMETER  VALUE
ASDF         6
XCV      34
ERT      1
TDED        14
GHT      3
GHB      2
BNHJ        17
QWE     17
DDD      9
YYY      8
KLO      7
POL      2
YUO     82
TRYU         2

The Pie chart hides parameter "ERT" with value "1". while remaining ones are properly displayed.
What change I have to do to display every single value in Pie-Chart, even if its very small.
I have added this line in XML too:

charting.chart.sliceCollapsingThreshold = 0

, It removed the "others()" tag but didn't solved the issue

Please Help...!!!

[yuanliu]

Not sure what you see, but this works in my instance.

Data emulation is

| makeresults
| eval _raw = "PARAMETER  VALUE
ASDF         6
XCV      34
ERT      1
TDED        14
GHT      3
GHB      2
BNHJ        17
QWE     17
DDD      9
YYY      8
KLO      7
POL      2
YUO     82
TRYU         2"
| multikv
| fields - _* linecount

[jasonwagner]

Yes, in your screenshot example it works because your pie chart is large.  Reduce the size of the pie chart and you'll notice how fields start to disappear.  This is even more apparent when one or multiple fields are much larger values than all of the others.  This happens to me even if you change the "Minimum Size" = 0.

[yuanliu]

Do you mean to say pie chart is not showing labels on smaller slices?  This is what I get when I really press down both graph size and smallest slice. (0.41% is currently the smallest.)  Yes, outward labels for smaller slices have disappeared.  But each slice is still present; if I mouse over them, their individual labels, values, and shares still show (second screenshot)  This seems to be a sensible use of real estate.  Then, if you have many especially small slices, there will be a limitation as to whether your mouse cursor could land on a given slice.

 

This is my new emulation

| makeresults
| eval _raw = "PARAMETER  VALUE
ASDF         6
XCV      34
ERT      1
TDED        14
GHT      3
GHB      2
BNHJ        57
QWE     17
DDD      9
YYY      8
KLO      7
POL      2
YUO     82
TRYU         2"
| multikv
| fields - _* linecount
| sort VALUE

[venkatesh296]

Hi,
Increase the size of the chart by
< option name="height">450px then you will see.

Thanks

[jasonwagner]

This worked for me.  My pie chart was just one of a few panels in a dashboard's row.  When I would open that panel search on its own, even fields with small values would be shown because it was a pie chart in its own "row".  Moving my pie chart into its own dashboard row and making it larger then showed small values in the visualization.  Sadly, I have not found any other changes to the visualization settings, search parameters/settings, that would force a small pie chart to show all fields that have small values.  Quite annoying.

[NOUMSSI]

Hi,

At the end of your query add this:

your_statistical_query|SHOWOTHER=f

[venkatesh296]

Hi Noumssi,
It didn't worked. Please help anyone.

Thanks