Hi ,
I have to prepare a dashboard which needs to display the Order delivery status using "Traffic lights. and the Algorithm works like:
- If the Actual Delivery time stamp (Column Name : Actual_Time) of order is less than or Equals to committed SLA (Column Name: SLA ) then --> GREEN Traffic light
2)If the difference of actual Delivery time stamp (Column Name : Actual_Time) and committed SLA (Column Name: SLA ) is less than 24 hours --> AMBER Traffic light
- If the difference of actual Delivery time stamp (Column Name : Actual_Time) and committed SLA (Column Name: SLA ) is MORE than 24 hours --> RED Traffic light
I have derived the difference the time difference between Actuals and SLA and stored it in a separate column.
Now how to present this column as Traffic lights ? Do we have any available Plugin which could be used here? Please Suggest?
