Hey guys,
I'm still fairly new to Alteryx but have caught on pretty quickly with some basic data prep. I now need to combine 2 existing calculations. I have one (below) that calcs tenure for all of my clients
IF isnull([END_DATE])
THEN DateTimeDiff(DateTimeToday(),[START_DATE],"months")
ELSE DateTimeDiff([END_DATE],[START_DATE],"months")
ENDIF
I now need to run this same calc but on a subset of clients. So i don't dilute my tenure I need to determine the tenure for my "Termed" clients. To determine my termed clients I use the below calc to determine my true "Termed" clients
IF [TERMINATION_REASON] = "No Start" THEN " "
ELSEIF [TERMINATION_REASON] = NULL() THEN " "
ELSE 1
ENDIF
I need to calculate the Tenure of my clients that meet the "1" criteria in the above calculation.
FYI, This work flow is replacing a manuel effort that ultimatily feeds into a preexisting Tableau dashboard that I didn't create so I'm stuck using the same logic as was used intially.
Any help would be greatly appreciated.
BC
Solved! Go to Solution.
I think that this is what you're after:
IF [TERMINATION_REASON] = "No Start" THEN " " ELSEIF [TERMINATION_REASON] = NULL() THEN " " ELSEIF isnull([END_DATE]) THEN DateTimeDiff(DateTimeToday(),[START_DATE],"months") ELSE DateTimeDiff([END_DATE],[START_DATE],"months") ENDIF
Cheers,
Mark