Hi Community!
I think this challenge will be solved by using sets, but I have much to learn about sets and hope someone can point me in the right direction for this particular case.
Suppose I have a dataset with 3 columns: year, station, and data, in which not every station has a data value in every year (see table below, also attached). My goal is to create a subset that contains only the stations that have data for every year within a user-selected time frame while excluding stations that do not have data for every year in the selected time frame.
For example, using the data table below, if someone selected the full time series, 2009-2018, only stations 2 and 4 would be part of the set. However, when 2009-2011 is selected, all 4 stations would be in the set.
Any advice on how this would be achieved?
Big thanks
YearStationdata200910.3200910.69200920.3200920.34200920.9200920.12200920.61200920.41200920.32200920.77200920.82200920.65200930.98200930.59200930.94200940.2200940.68200940.08201010.53201010.91201010.24201020.29201020.77201030.44201030.91201030.51201040.02201040.03201040.25201110.16201120.01201121201120.48201130.41201140.35201140.36201220.55201230.98201230.24201230.09201230.21201230.16201230.48201240.21201240.83201240.13201241201310.93201320.05201320.52201330.7201330.05201340.78201340.9201410.06201420.54201420.2201430.38201430.86201430.76201440.75201440.8201510.76201510.87201510.09201510.07201510.69201510.2201521201520.98201520.88201540.32201540.02201610.25201610.35201610.8201610201620.99201630.78201630.28201630.77201630.77201640.76201640.68201720.36201720.08201720.83201720.77201730.15201730.23201730.04201740.95201740.01201740.44201820.35201820.54201830.47201840.31201840201840.05
Row Labels2009201020112012201320142015201620172018Grand Total10.991.680.160.930.062.681.47.925.241.061.490.550.570.742.860.992.040.8916.4332.511.860.412.160.7522.60.420.4713.1840.960.30.712.171.681.550.341.441.40.3610.91
