Dataset returning multiple records - need to filter down to the newest

Question & Answer
, ,
1

image
image1382×448 21.4 KB

HI all
I’m trying to work out how to filter down to the newest record - in the screen shot this would be datecomp = -1. all the duplicates are older records and i need to filter them out.

Thanks

2

Hello @evansstu,

Welcome to QuickSight Community, it is great to have you here!

Have you looked at Top and Bottom filters, I think they should work well for your use case.

image
image702×522 26.7 KB

Hope this helps!

Kind regards,
Andres.

3

Andres.

Thank you so much… works a treat !!

1 Like