Hi there.
I have an issue where I have multiple rows with a workflow of 'Published' all with different 'Valid_to' dates.
I'm trying to get it where only the row with the Max valid_to date (furthest out date) shows. I have tried a few things but I can't get it to work. even is SQL I tried using something like but I know if doesn't work but might give you an idea of what I'm trying to accomplish.
Case where workflow = Published and Max(vaiid_to) then 'Published'
ELSE 'workflow'
END
Any help would be appreciated
thanks,
--Brian
@Brian Fornelius
Hi, in this case you may try with something like:
IF {FIXED [Work ID]:MAX(IF [Workflow]="Valid" THEN [Valid_To] END)}=[Valid_To]
AND [Workflow]="Valid" THEN "Published" ELSE "Workflow" END
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
