I have a two csv tables that have been related to eachother (RelatedResults):
Table 1 = Locations which is loaded as points Which has the fields[ID] [Type] [X] [Y]
Example: Point_1, Frogs, LAT, LONG
Table 2 = Results which is loaded as just an attribute table Which has the fields [ID] [Year] [ResultA] [ResultB]
Point_1, 2017, 2000, 4000
Point_1, 2018, 6000,150
I am trying to label the points based upon the year of sampling and every time I try to do it will only label using the result from 2017.
I have tried:
relation_aggregate( 'RelatedResults', 'count', CASE WHEN "Year" = '2018' THEN 'true' ELSE Null END )
Label Expression Generator
attribute(get_feature('Results', 'ID', ID), 'ResultA')
Not sure what I am doing incorrectly to get this to work as it will only ever show "2000" from the first year of results.
Any help would be amazing guys :). I have been stuck on this for a couple of days now. I need to produce concentration contours across a large areas for each year going back to 1985...