How to display only the latest data?

Question & Answer
, , ,
1

The columns contain datetime (milliseconds) and number of items.
Is there a way to display the latest item number?

example
2024/12/01 00:00:00.000 | 1
2024/12/01 00:00:00.500 | 2

I want to display 2.

The filter doesn’t seem to be aware of milliseconds.
Also,when using the lastvalue function,it couldn’t be displayed in the KPI graph.

2

Hey @techtech1919 ,

a Top N filter on the Date didn’t work? I never tried it with milliseconds.

BR
Robert

1 Like
3

thank you for your reply.
yes,a top N filter didn’t work for milliseconds.

If the data differs by 1 second, it is displayed properly.

In this example,data for 2 is displayed,filtered appropriatey.
2024/12/01 00:00:00.000 | 1
2024/12/01 00:00:01.000 | 2

2 Likes
4

Yeah looking through the documentation: Adding date filters - Amazon QuickSight sadly there don’t seem to be the option to filter for milliseconds.
Your approach seems to be the best solution. Good to know for me if I ever have to work with milliseconds :slight_smile:

2 Likes