Issue with creating a map visualization.

[Neymar_Jr]

I want to create a map visualization which uses the dimension as Region and measure as Sales. Now, i want the map to show only the sites which has negative ebitda. How do i do that?

Thank you!

[lironbaram]

hi

try something like

Dimension : Region

Expression : if(Ebidata<0 , Sale) , this should only show you the relevant regions

[arulsettu]

can you share sample app

[agigliotti]

maybe this:

Dim = Region

Measure = Sum( if( ebitda < 0, Sales, 0 ) )

and finally disable show 0 values option.

[Neymar_Jr]

Hi Liron, i used your expression.This is what it shows now.I only want the bubbles not the crosses. Can you help me with that?

Thank you!

[shraddha_g]

Are you using any extension?

[Neymar_Jr]

Yes, i am using variable extension and that is used to change the value of sales and ebitda.

[shraddha_g]

No I am asking about Map

[Neymar_Jr]

No, for map i am using the default map.

[Neymar_Jr]

Done!

I used the following expression as measure:

if(ebitda<0,Sum(Sales),0)

and then i unchecked Include zero values.