Difference between the data of latest two dates

Rajakumaranakash · ‎2025-02-20

I want to get the data difference from latest 2 dates. For Example

I want to get the result as below.

Newly Added Name

Richard

Removed Name

Tom

Can someone help on this?

Chanty4u · ‎2025-02-20

Try this

Concat(DISTINCT {<[Date]={"$(=Max(Date))"}> } Name, ', ') -

Concat(DISTINCT {<[Date]={"$(=Max({<[Date]={"<$(=Max(Date))"}>} Date))"}>} Name, ', '

)

morgankejerhag · ‎2025-02-22

I am not sure how you mean - Richard, which is only present in the last day (20th) is flagged as removed?

rubenmarin · ‎2025-02-22

Hi, names added on last date that was not present in the previous to last date (Added?):

Concat({<ID=P({<Date={"$(=Date(Max(Date)))"}>} ID)-P({<Date={"$(=Date(Max(Date)-1))"}>} ID)>} Name, ', ')

Names present in the previous to last date that not exists on max date (Removed?):

Concat({<ID=P({<Date={"$(=Date(Max(Date)-1))"}>} ID)-P({<Date={"$(=Date(Max(Date)))"}>} ID)>} Name, ', ')