I have a dataset that contains multiple records for users. I only want the latest record for each user and I’m trying to do this at the dataset level.
I have a calculated field that calculates a row number for each user based on an UpdateTimestamp field:
I then assign a value of 1 to the latest record:
When I try to filter by Latest Record, I get a syntax error:
Is this because there are restrictions on what can be used as a filter in a dataset?