Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a bar chart that I have selected to remove the zero value under data handling which is perfect, but when I make a selection on the map and the bar chart adjust to that selection is shows zero values. Can that be removed?
I am attaching two pics once showing how it is set to remove the zero values, then what it looks like when I make a selection on the map.
Thank you!
It might be having values in decimal after 0. That might be reason that it is appearing even after removing zero values
I agree with Shraddha, It is because of decimal value.
Use round or ceil () to make it 0.
Regards,
HI,
Thank you but no that's not working. I'm thinking I should add something to my expression to overlook the zeros.
I currently have this: =Count({<[New / Revised]= {'NEW'}>} EP#)/16
what do you want to do with such lowest value??
If they're there, It means that are not zeros !
Try to format ur expression with 2 numbers after the , and u'll see !