Join based on filter criteria
Table A (Completed Evaluations w/ dates & locations)
Table B (Locations Universe, all available locations)
Table A has all the same location columns as Table B. Table A also has completed dates and evaluation data,
We want to show locations with completed evaluations for a user specified date period (i.e. using a date filter card)
Card 1 can show the locations completed (easy enough)
Card 2 we want to show the locations that were not completed during the user specified date criteria.
i.e. Card 2 should show all Table B locations minus the locations completed during the user specified date period. The user chooses the date range for Table A in an embedded dashboard. Then somehow (beast mode?) filter Table B based on the locations not in Table A.