I have a large set of dashboard filters that I am trying to get to change their options based on what results are currently loaded.
My dashboard involves checking results for a certain day. Within the data you can for example filter per employee who has a row that day, this means that I only want to see employees that actually have rows for that set day.
As it is currently, I can see all the available employees in the field filter.
I am quite certain this is functioning for other dashboards but it doesn't seem to work here.
My relations are setup correctly in the datamodel.
They are all SQL queries and the dashboard filters are linked to each other.