Hello Tableau Community!
I am trying to create a visualization showing me the contracts expiring within the next two years. I am assuming the best approach is to create a calculation.
Does anyone have thoughts on how to best achieve this?
Charlie
5 réponses
@Charlie Mouy
In this case you may use a calc like this.
DATEDIFF("day",TODAY(),[Si Cntrct Expire Dt])>=0 AND DATEDIFF("day",TODAY(),[Si Cntrct Expire Dt])<=720Then drag to the filter shelf and use the true value.
If this post resolves the question, would you be so kind to "Select as Best"?. 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 Forums Ambassador
