Max of String in QuickSight

Hi everyone,
How can I take the max of string in quicksight. I found that we can take the max of measure only but cannot take the max of string unlike in MySQL. Thanks,

Hi @Santosh -

You can use lastValue - Amazon QuickSight .

c_max_word_desc
lastValue(word,[word DESC])

c_max_word_desc
lastValue(word,[word ASC])

Example:

1 Like