Hi,
Request you to provide a solution on the below basis your expertise. Thanks in advance!
My queries:
- Sometimes the deadline column is taking the date on which the request had come in from the stakeholder rather than when the writer started working on it which is skewing up the data.
- While pulling out the report, how can I see - how many requests were completed on time, before time, etc. Currently there is no split option available for the deadline column.
Background:
We receive requests to create content pieces like whitepaper, blogs, etc. for which I want to track the turnaround time. Our SLA is calculated basis when the content strategist starts working on it minus when he/she delivers the first cut to the stakeholder.
I have created these columns -
- Deadline - I have set up the automation basis each content asset i.e. if it is a paid media copy then the SLA is 5 business days. The deadline date should be calculated basis when the writer starts working on it. When the writer starts working on it, then the request is moved to the “In progress” stage and the deadline date is keyed in.
- Start and completed date - These dates are keyed in by the system when the writer starts and delivers the work. When the writer moves the request to “working on it” group, the start date is keyed in and when the first cut is ready and request moved to “stakeholder review”, the completion date is logged by the system.
- Turnaround time - This column is the summation of “completion date” minus “start days” and is the total number of days it took to complete the job.
The deadline column shows these labels:
- Red exclamation mark - Not yet completed and we are past the due date
- Green exclamation mark - Completed but after due date
- Tick mark - Done on time
Looking forward to a fruitful conversation.