I am trying to create a card that drills down to another dataset, but matches values based on a specific column in order to show rows for the selected category.
For example, the card categorizes employees based on country (dataset A). When I click on US employees, I want the card to drill only show me US employees BUT using dataset B to do so. Basically, this would require some sort of match by column, but I have no idea how to do it.
P.S. it has to be a different dataset due to PDP settings.