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?
try something like
Dimension : Region
Expression : if(Ebidata<0 , Sale) , this should only show you the relevant regions
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?
Are you using any extension?
Yes, i am using variable extension and that is used to change the value of sales and ebitda.
No I am asking about Map
No, for map i am using the default map.
can you share sample app
Dim = Region
Measure = Sum( if( ebitda < 0, Sales, 0 ) )
and finally disable show 0 values option.
I used the following expression as measure:
and then i unchecked Include zero values.
Thank you all for your help!
Retrieving data ...