How to get the latest date on my data?

Question & Answer
,
1

Hello, I got this table so I want to display the latest date of my test date which is Feb 2, 2024 to be in the verified date
image

is that possible?

2

Hi @danielreyes3rd

did you checked out

lastValue
	(
	     {Test Time},
	     [ {Test Time} ASC ]
	)

BR

3

Thanks Eric but Sorry my bad, my plan is to identify which is the last date or latest date on the test time. Example if Test Time is the Latest Date print 1 else 0. Is that possible on quicksight?

image

4

Try

ifelse({Test Time}=maxOver({Test Time},[],PRE_AGG),1,0)

1 Like
5

thanks it worked for now

1 Like