I have a due date column. I can do a date difference calculation from Today's date. I need help on creating and output label based on the number of days left from the due date.
So as an example if I have a calculation of 6 days left I want it to be labeled Due Date Near. if Its passed the Dude Date I want it to Say OVERDUE with the Color Red. Below are labels and color codes for each.
|Due Date Near||Yellow|
So I suppose That you already fixed Criteria based upon Number of days, So Create this Calc and Drag it To Color
IF (Measure)="On Time" THEN "Green"
(Measure)="Due date Near" THEN "Yellow"
(Measure)="Late Hazard" THEN "Orange"