LAST Value but not include field ID in visual

[ctine]

Hi,
I need to get the last transaction date of all customers.
And was able to do this using “lastValue” but it requires the partition field to be in visual. is there anyway do to it?

Thanks

[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 …