LAST Value but not include field ID in visual

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?


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:

1 Like