Hello,
I am looking to create a "Tenure" calculated field. It would look at the Hire Date and assign their tenure:
If Hiredate is < 3 months from today call the group "0-3 months"
If Hiredate is between 3 months and 12 months from today call the group "3 - 12 months"
If Hiredate is >12 months from today call the group "1 Year+"
How can I set this up in tableau?
3 réponses
This might be the easiest way
if datediff('month',hiredate,today()) < 3 then '0-3 months'
elseif datediff('month',hiredate,today()) > 12 then '1 Year+'
else '3-12 months'
end
