Selecting value based on latest date

Wojciech Glowacki
Wojciech Glowacki Contributor
in General

Hi,

yet again I need assistance. I have 2 columns. One is an ID column, the other is a Data column. There are multiple entries of the same ID. I am looking for a way to select/filter out only those ID's with the latest date.

Thanks in advance for any tips!

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Group ID column and Max Date aggregate:

    image.png
  • Wojciech Glowacki
    Wojciech Glowacki Contributor

    Hi Josh,

    thanks for your answer. Is there also a function that can do this?

  • Josh Boxer
    Josh Boxer Administrator

    No, think of it like this:
    Functions look at individual values/rows. Workflow steps/Actions look at entire column(s)

Categories