Description
Use a calculated variable to display a categorical amount of time between two dates of interest.
How To
Table:
The final table could look like the below image. In this example, the column of time categories designate the number of weeks before a phone call is due.
...
var dateDifference = diffInDays(V3, V4);
var weeks = Math.roundfloor((dateDifference / 7) + 1);
return weeks > 3 ? 3 : weeks;
...