How to get the latest date on my data?

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

is that possible?

Hi @danielreyes3rd

did you checked out

	     {Test Time},
	     [ {Test Time} ASC ]


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?



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

1 Like

thanks it worked for now

1 Like