I'm trying to stores all previous values for a user in new Calculated field.
|user id||Plan||Expected OutPut|
expression I am writing is its throwing me an error..
if [User_id]= LOOKUP(max([User_id),-1)
I'm new to tableau . so facing lot of difficulty writing expressions. any help will be appreciated.
i think you are very close.
Try changing to:
if attr([User_id])= LOOKUP(max([User_id),-1)
That should fix the issue. Sorry no one replied before now.