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"
I have such a simple question I am ashamed of asking I created a workbook that shows a date difference (working days) between two dates. It creates a table with several rows with each row having a an specific total of the date difference. I want to add the totals from all the rows and divided them by the number of rows , to get an average. The average feature in Tableau seems to be off by 2. By the chart above the sum will be 138 / its divided by the number of rows (11) giving me 12. But the average feature on tableau gives me 14 using my Validation Approval Time measure.