Most Recent Date (repeated days with different hours)

[coy]

Hi everyone,

I am struggling as I have this:

 And I need a visualization able to show ONLY the row corresponding to the last period of time. In the example above, it would be:

Temperature | Pressure | H2 Partial Pressure | Damage Factor | Last Date: Date

44,8800586   |  175,65   |           166,86          |         0,00           |  10/03/2018 23:00:00

I´ve tried with LASTDATE, however, it seems not to be working as the data has different hours in the same day.

I would really appreciate if anyone could help me with the solution.

Many thanks

[Thim · Accepted solution]

Hey there.

Maybe a Top N can help you archive this.

Try set up the date in your table with a filter like this.

This should update your table to only show the latest date within your filter.

Hope this will help. 🙂