I am building a weather station Dashboard which contains a map with external links to a variety of different weather stations from various sources. Each station has a unique combination of variables such as precipitation, temperature, relative humidity, etc.
I built the main table which contains a column for each weather variable and then assigned TRUE or FALSE for each variable at each station.
For example, Station 1 has only wind + temperature, Station 2 has precipitation + temp + RH, Station 3 has only wind + RH.
I would like to add a selector to my Dashboard which would allow me to only show the weather stations with a specific variable (or ideally the option to select multiple variables) so that if I selected Wind, it would only show stations with wind (Station 1 and 3 from the example above).
I have also tried concatenating the variables into a single field but so far haven't had any success. In this case, Station 1 has the variable "wind, temp", Station 2 is "precip, temp, rh" and Station 3 is "wind, rh". I was told to use the "contains" option but this does not appear to be available on the selector options, only seems to be an option in the filter menu.