Hi, i am working on a dashboard with selections of Coutries, regions, and facilities. the user wanted a multiple dropdowns as they wanted a specific structure. for each filter - i have a dropdown for the country, a separate one for the region and facility. i opted to use iland tables for each of these filters. i then use set analysis to limit the reports to only those that are selected. each of these selections are againt a single ENTITY field.
so i would compose all the selections into a string like the following an store in a variable 'USA','CANADA','REGION1','FACILITY1' etc.. depending on what the user selects
then in the set analysis i wold use {<ENTITY={$(vEntity)}>}
when i use this in a table and have ENTITY and the measure - it works perfectly as you would expect.
now im asked to create a map but only for Facilities (LONG/LAT are added to the DM) - plotted it using point layer. im using a measure to control the bubble size for the point. that has set analysis in it similar to above.
since the measure/set analysis is used only on the bubble size it does not limit he Facilities to plot. if the user selects only 2 Facilities from the drop down, the map plots all the facilities (majority with Xs and only 2 with a bubble)
it appears that the user actually has to select the field im mapping - ENTITY. the problem here is that ENTITY has more than facilities - it has countries and regions.
SO the question is how do you limit the field values to plot using set analysis? and not filtering the field itself?
if my field is
ENTITY
ENTITY TYPE
USA
Country
CANADA
Country
REGION1
Region
REGION2
Region
FACILITY1
Facility
FACILITY2
Facility
FACILITY3
Facility
i have an island table that contain only the Facilities. user selects this field
i map the field ENTITY
how do i limit the facilities mapped only to the facilities that are selected?
