Filtering data based on most recent transaction date

Q&A
,
1

I am looking for a way to filter a table so only one row shows for each unique id. The row that would show would be the most recent transaction date. I have a date field called date and just need to keep only rows where max(date, unique_id) is equal to date. I am currently getting an aggregation error if I try to create a boolean flag, to be able to filter on this flag. Is there another workaround?

2

Hi @mroo11,
What if you created a denseRank calculation for this. Then you can create a filter for this calculated field to show only those that equal ‘1’.

I’ve created an example in Arena view for you to explore:
Filtering data based on most recent transaction date

Let me know if you have any additional questions.

3

Hi @mroo11,
Following up here as it’s been awhile since we last heard from you on this thread. Did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @mroo11,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!