I want the final data to look like this in the app:
01/01/2021 | John Adams | Tokyo | Sales
01/01/2021 | Mark Smith | Chicago | Analytics
01/01/2021 | Dan Williams | London | Illustrator
As you can see, I pulled all the data from the most recent data the was appended to my dataset. I need this to be an expression that I add to formulas for charts, tables, and KPIs - it cannot be a restriction in the data load editor (because the full dataset is used is a section of the app).
Does anyone have a formula or something that can help me do this?