LAST Value but not include field ID in visual

[David_Wong]

You can try to use the rank function and hide the columns that you don’t want in your visual.

See if this post helps:

When to use lastValue instead of rank

Hi, I’m trying to figure out the use case for the firstValue or lastValue function. So far what I’m finding is that it’s easier to use the rank function to do the same thing. Is there a particular use case where the firstValue or lastValue function is better than the rank function? Let’s say for example I want to find the last status for each id in the dataset below. [lastValue versus rank] If I use lastValue on the status field, I have to add all the fields to my visual in order to not get …