I have a card that is created by counting IDs and when I drill down into the card, it shows all the rows for that ID. I just want to show unique rows for a user ID. Attached is the screenshot for my data.
I want my drill down to look like this.
Basically, I want to remove the duplicates in the drill down. Is there any way to do it in the card using beast modes?
Thanks.