topic Re: Excluding zero values on a map chart in App Development

Excluding zero values on a map chart

Aika — Tue, 27 Jul 2021 10:48:45 GMT

Hi,
I have a map chart and I need to be able to exclude cities with zero values.

For example I would like the city "Mara" not to appear on the map because it is associated with a value (n° debitori paganti) = 0

I am trying with the following function:
if (debtor_number = '0', Null (), city)
then I exclude null values from the map properties, but it doesn't work ...
How can I do?

This is the map:

Re: Excluding zero values on a map chart

wayne-a — Tue, 27 Jul 2021 10:57:11 GMT

Hi, not sure about the map chart but other charts have an "Add Ons" property with a "Data Handling" setting. By default it is checked to include zero values, you can uncheck it to exclude them.

Re: Excluding zero values on a map chart

Gui_Approbato — Tue, 27 Jul 2021 12:16:44 GMT

Hello Aika,

You can use the Aggr function in the dimension.

Instead of City in the dimension, use it wil a condition (similar with what you did but a but with a plus):

Aggr( if(debtor_number <>'0', City ) , City)

Check if it works.

Regards

Re: Excluding zero values on a map chart

Aika — Tue, 27 Jul 2021 13:43:59 GMT

thanks it works!