I am trying to get the number of years of tenure from the number of Tenure months in Tableau with a function? can someone help me? Thank you
Asked
Active
Viewed 33 times
1 Answers
0
If you need to get the number of years and number of months, you can create a new calculated field using the below
STR(INT([Tenure Months]/12)) +' Years '+ Str([Tenure Months]%12) + ' Months'
If you just need the number of years in float, you can create a new calculated field using the below
[Tenure Months]/12

Pubudu
- 27
- 1
- 5
-
Thank you so much Pubudu. You were amazingly helpful! – Gabriel Mesa May 17 '21 at 14:47