2 Replies Latest reply on Jan 14, 2016 8:06 AM by Dan Sanchez

# Percentage of orders completed on Time (in calendar days, hours & minutes)

Hi All,

We issue work orders/Jobs to contractors to repair properties and want to calculate percentage of orders completed on Time (in calendar days, hours & minutes) – This measures the time between the date/time the repair request is received by maintenance team and the date/time the works are completed by contractor. Below is the KPI for each category.

The challenge I'm facing is how to calculate and show in the dual axis pie chart in percentage how close we are to the target per month. Something similar to the chart in the link below

http://vizwiz.blogspot.com.au/2014/12/donutcharts.html

 Category KPI Target Urgent 4 hrs 100% Category 1 24 hrs 99% Category 2 72 hrs 99% Category 3 20 days 99%

I have upload sample data and the date columns are explained as below:

Requested Date: The date the repair request was received

Ordered Date: The date the work order was sent to contractor

Required Date: When the work is required to be completed.

Completion Date: When the work was actually completed

I would like to show the viz as in the attached screenshot.

Thanks

Jag

• ###### 1. Re: Percentage of orders completed on Time (in calendar days, hours & minutes)

Hi Jagit,

I'm having a go at this and am looking at your data. Where you for Null values for 'Completion Date' does that mean that the order is still in progress? Even when the required date is way overshot?

I'm thinking about creating an order status so where we have Completion Date is null and the required date < today's date then the order is 'Overdue' and were required date is > today's date then the order is 'In progress'.

Is that how your data should be interpreted?

Thanks,

Stephen

• ###### 2. Re: Percentage of orders completed on Time (in calendar days, hours & minutes)

Hello Jag!

I have attached a sample workbook using your data.  The first hurdle was stitching together the date and time columns into a single calculated field.  Next I followed the steps in the following KB:

Creating Donut Charts | Tableau Software

Let me know how it looks.  Thanks!

2 of 2 people found this helpful