I have an Individual object with Individual ID and an Engagement object with Engagement ID, Individual ID, Engagement Name and Engagement Date. The two tables can join on Individual ID. I want to create a metric which shows me the Engagement Name for the last engagement an individual had, defined by the latest Engagement Date which shows up for this individual. How can I achieve this? I've been trying to think of Data 360 transforms which could let me join the tables and aggregate them in the right way but I haven't been able to figure it out, and I'm not sure if it's possible to do this in a Tableau Next semantic model. Is this totally impossible or is there a way to do it that I'm just not aware of? Any help would be hugely appreciated.
Hi, you may create a calculated field to obtain the max engagement date
Max Engagement Date
{FIXED [Individual ID]:MAX([Engagement Date])}With the Max Engagement Date, then you can create another calc:
Last Engagement Activity
{FIXED [Individual ID]:MAX(IF [Engagement Date]=[Max Engagement Date]
THEN [Engagement Name] END)}
If this post resolves the question, would you be so kind to "Accept this Answer"?. 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 Tableau Ambassador
