Filter rows equal to latest date

Showcase
1

Hi,

I’m trying to find a way to filter all the rows that are equal to the latest “date of request” column (whatever the latest “date of request” is). There’s a little trick, it should not take into account when the “date of request” only differ in seconds.

Example here: https://coda.io/d/filter-latest-modified-date_dw2e43kWspl

In the example above, the result should be:
|Campaign Name|date of request|
|May 2020 - 1.Awareness - EN/International/MF_29-54_Parents - Feed|5/22/2020 1:00:55 AM|
|May 2020 - 1.Awareness - FR/Brussels/F_35-54_Parents - Feed|5/22/2020 1:00:55 AM|
|May 2020 - 1.Awareness - FR/Brussels/F_25-34_Parents - Feed|5/22/2020 1:00:56 AM|
|May 2020 - 1.Awareness - FR/International/Expat_M/F_29-54_Parents - Feed|5/22/2020 1:00:56 AM|
|May 2020 - 1.Awareness - FR/International/Expat_M/F_29-54_Parents - Feeds&Stories|5/22/2020 1:00:56 AM|
|Post: “The month of May is the perfect timing to…”|5/22/2020 1:00:59 AM|

Thanks for your advice!

2

Hi @Jeremy_Corman. You can do this by finding the largest (or maximum) value and then filtering so that each row equals that maximum value. Try this:

thisrow.[date of request] = thistable.[date of request].max()

(your permissions don’t allow me to edit or copy your doc, so I couldn’t test but I think that’'ll do the trick :slight_smile: )

2 Likes
3

Hi @Johg_Ananda,

I hadn’t thought about max(). Now, I think I see how I can make it work! Thanks for your answer! :slight_smile: