I have the Deal ID / Opportunity ID whose stage changes over time, I want to show both stages in a single row for any two selected dates.
I used a parameter to select date and set up the 'TM - Stage - Retrospective Date' using the following calculation:
IF [Record Upload Date]=[TM - Retrospective date (Time Machine)] THEN [Opportunity_Status__c] END
Same for Present Date:
IF [Record Upload Date]=[TM - Present Date (Time Machine)] THEN [Opportunity_Status__c] END
But the problem is it doesn't return the values in the same row. Look at the picture below, can you please suggest how I can just erase the nulls in there and only show relevant values.
It took me some time but I figured it out:
{FIXED [Opportunity_Id_18_Char__c]:MAX(IF [TM - Record Upload Date]=[TM - Present Date (Time Machine)] THEN [Stage Name] END)}
This gets me only the not null values. This is how to get values based on specific date (tableau calculated field). Return string value using the fixed function tableau.
