Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I want to control when a layer is shown on the map but I am not sure how to control that aside from using the restrict drill down field. I have a few area maps that this works well for going from State, to county to zip code, however I want to show a heat map only when the county layer is active. Since the heat map doesn't use the same dimension the others do I cant use the restrict drill down field.
Any thoughts, or suggestions?
Use count distinct to build up an expression.
For example
count(total distinct country)=1 and count(total distinct state)=1 and count(total distinct county)>1
to check if only one country, one state and several counties is selected.
Thanks,
Patric
Use count distinct to build up an expression.
For example
count(total distinct country)=1 and count(total distinct state)=1 and count(total distinct county)>1
to check if only one country, one state and several counties is selected.
Thanks,
Patric
Thanks I was missing the "=1" part of that formula.