firstValue w/o requiring the ID field in the visual

[David_Wong]

Can you try to use the rank function instead? For my use cases, I’ve found that it works better than first value or last value.

Take a look at this:

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 …