asked on September 16, 2016
Hi,
We are creating pie chart from the data which has zero value for the measure in few rows. These rows are also been displayed in pie chart. Is there any way to filter out zero value measures from being shown in pie chart.
⋅ September 16, 2016
Hello Bhagvan,
Thank you for the question.
The only possible way to achieve this is to replace zero values ("0") to an empty string ("") in the data.
For example:
d+From Date,d+To Date,Material name,-Quantity in T
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Paint Sludge,62.89
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,E-Waste,
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Bio Medical,.0326
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Softening Rision,
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Paint Sludge,156.81
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Barrels/Drums,
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Oil/Oil Waste,9.4605
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,E-Waste,
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Softening Rision,
2015-04-01 00:00:00 UTC,2016-03-31 00:00:00 UTC,Bio Medical,
So, the component will hide this values both on the charts and grid.
Hope it helps.
Regards,
Ian
⋅ September 17, 2016
Thanks lan for the solution. Besides this we tried putting filter on quantity and that works when I try it on flexmonster demo but somehow filter on this field is not reflecting on the instance we have. Filter on some other fields works but not on quantity. Under filter we see 0.0 instead of 0. But same is the case on demo flexmonster website and it works there. Any pointers what could be an issue.
⋅ September 19, 2016
Hello Bhagvan,
Thank you for the feedback.
When the component receives the "0" value, it will show this value in the pivot and in the the charts, but when it gets the empty string ("") or "null" value, it will skip this row and will not show it. The solution we gave you allows not to add this rows to the result.
You were talking about the Quantity filtering but it is just the members filtering and it will not give the result you are looking for. Here is your data cleaned from zero values (http://take.ms/7ECTa). As the result, there are no "0" values in the pie chart or grid (http://screencast.com/t/zNudEuZfo1vF). It is the best we can suggest you.
Regards,
Ian
