I'm not sure that I understand exactly what you're trying to do. Would you be able to post a sample workbook with specific details for the desired ultimate outcome?
I think you need both Parameter and Calculated field.
correct me if I misunderstood you,
set parameter, value as 0.5 etc, display as name of region that end user could understand.
from there, create calculated field, assign that parameter in formula that you want to adjustments.
hard to picturing without actual workbook.
I do realize it was a bit unclear. Here's a viz. What I want to happen is the following:
If someone clicks "Tolbert" then the map values of nodes in the region Tolbert should be raised by 50 cm.
Same for Wolddiep. If someone clicks that, then the map values of nodes in the region Wolddiep should be raised by 0.5m
(Oh by the way: if you don't see the Elevate Dikes checkboxes that's because the thumbnail could not be refreshed. If you actually open the viz, you'll see it.)
Not sure I understand either, but you can write something like:
when "Tolbert" then avg([Waakhoogte (cm)])+50
when "Wolddiep" then avg([Waakhoogte (cm)])+500
else avg([Waakhoogte (cm)])
And use that new field on the Label shelf. But again, I'm not clear on what you are hoping to do and your annotations are making it more difficult for me to understand what you're hoping to accomplish.
Hi Matt, I appreciate your help, but hat's not what I meant.
If Wolddiep.checked then avg(Waakhoogte) FOR REGION WOLDDIEP + 50 cm.
If Tolbert.checked then avg(Waakhoogte) FOR REGION TOLBERT + 50 cm.
So multiple checkboxes must be able to be active simultaneously and ONLY the nodes in the corresponding regions should be raised by 50cm....
The whole problem so far is that I've only been able to raise ALL nodes by 50 cm, but not only subselections....
The main issue seems to be that there is no multiselect paramter, however, this should fix it (with a bit of work)
Create a parameter for each region (string) with the region name as value (display as "True") and 0 (display as "False")
Then create a calculated field with:
if([Parameter 1] = [Region]) then 50 else 0 end +
if([Parameter 2] = [Region]) then 50 else 0 end +
(might want to divide the 50 by number of records)
Result: You get a lot of parameters which you can set to true or false, if they are true, the calculated field compares the value with the region name, if it's the same, it will add the specified value to that region alone.
*Hope you don't have many regions and that you don't want to program interaction between regions