Forum Discussion
Dynamic Range for Shapemap Legend
Hey, I have a simple enough table, as below (not full table) Local_Authority Policy Type Count Kerry County Council Policy 1 1 Roscommon County Council Policy 2 1 Sligo County...
Hey,
The logic for the range, that i've been trying to use, is a simple Swith() or nested If statement. Something like,
Dynamic Legend =
SWITCH(
TRUE(),
Sum(TypeCount) > 30, ">30",
Sum(TypeCount) > 20 && Sum(TypeCount)<= 30, "20-30",
Sum(TypeCount) > 10 && Sum(TypeCount) <= 20, "10-20",
Sum(TypeCount) > 1 && Sum(TypeCount) <= 10, "1-10",
Sum(TypeCount) < 1, "0"
)
or the equivalent in an if statement. But this isn't working.