Forum Discussion

Birdjo's avatar
Birdjo
Icon for Resolver II rankResolver II
9 years ago

Filter Report by Max Date

Hello, I am working on a human resources report where I have to use the different positions. But when our employees edit the positions new row appears, while I only need the latest version of the ...
Need Help
Birdjo's avatar
Birdjo
Icon for Resolver II rankResolver II
9 years ago

With inner join I get the duplicates from the other table. :smileysad:

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Birdjo,

You can directly create a table visual by setting Latest for MODIFIEDDATETIME as shown in the following screenshot.


If the above step doesn’t help, please share sample data of all columns in your table, and post expected result here.

Thanks,
Lydia Zhang