Hello,
I have included a map with a building data layer in my Dashboard.
I then use the sidebar in which I choose the “Category selector” option, then “Grouped values”.
So here I choose my “Year” field from my “Transactions” table because I want to filter my buildings on the map according to a specific year of transactions (the user has the choice via the filter of this year).
Except that once I get to the “Actions” option, I can't set a common ID for source and target fields. I automatically have the “Year” field selected, except that I don't have this field in my building layer (since several transactions can concern one building).
I'd like to know how I should set up my filter window so that I can filter my buildings according to the year chosen in the transaction table, and so that it ONLY keeps buildings with a common ID with the transactions corresponding to the chosen year.