Best Way to Group By at the Card Level
I have a dataset in which someone's name may appear in multiple rows, while the card I'm building is only looking for one row per person. This is a classic "group by" situation, but I'm blanking on if there's a way to do this in the card builder.
I'm showing name and start dates and my temporary workaround is using a count(distinct name) column in the table view. The data in the table I've built is the same for a single person, but there is apparent fan out. What's the best way to group by a name?