Card filtering to the most recent row based on rank
What I'm trying to achieve: Get the rows with the latest/smallest rank per user based on a given date. I created a calculated field called "Indicator" and I filter on it as "Indicator = 1". I wanted this field to indicate 1 when a transaction is the smallest rank number for a user and 0 if not. What my calculated field…