9 Replies Latest reply on May 13, 2013 11:30 AM by Marcelo Konatu

# How to find how I am delivering my orders X% of the time

Hello,

Imagine hypothetical situation: "We strive to ship 90% of our orders in 4 days" My goal is to create a report that monitors this shipping KPI.

To accomplish this task did the following (please see the incomplete sample attached):

1. Built a list of orders and sorted them in ascending order using the "time to ship" measure field.

2. Create a calculated field on the number of record that shows the % of that particular order within the data set.

3. With this list I know that I am shipping my orders in 5 days (based on the order 42,429)

My questions are:

1. How can I can get only 1 row that shows me when we hit the 90th% mark?

2. Is there a better/smarter way to accomplish what I am trying to do?

Thanks,

Marcelo.

• ###### 1. Re: How to find how I am delivering my orders X% of the time

Marcelo, you need to post a packaged workbook (twbx). The one you posted (twb) has not data in it.

--Shawn

• ###### 2. Re: How to find how I am delivering my orders X% of the time

Sorry about that. Here it goes the new file

• ###### 3. Re: How to find how I am delivering my orders X% of the time

Marcelo, I had to uninstall V7 to make room for 2013 Office (#bloatedsoftware), so I can't provide a workbook in V7, but here is the formula you're looking for:

First I created an integer parameter name [Number of Days]. Then put this formula in a calculated field called Shipping KPI:

SUM(IF DATEDIFF('day',[Order Date],[Ship Date] )<=[Number of Days] THEN 1 ELSE 0 END)/

SUM([Number of Records])

Here's what it looks like in the viz.

--Shawn

• ###### 4. Re: How to find how I am delivering my orders X% of the time

Hi Shawn,

Thank you for the example. What you displayed is the opposite of what I am looking.

I need to display the number of days to ship for orders that hit 90%. So using your example, I enter 90% and the report return back the number of days.

Thanks,

Marcelo.

• ###### 5. Re: How to find how I am delivering my orders X% of the time

Sorry Marcelo, that's getting into a table calculation I just can't seem to crack. Maybe Joshua Milligan, Jim Wahl, and Brad Llewellyn can help you out.

--Shawn

• ###### 6. Re: How to find how I am delivering my orders X% of the time

Marcelo,

This workbook does it two different ways.

1) Determines what percentage of Orders are under a certain number of days

2) Determines the number of days for which a certain percentage of orders are under.

Hope this helps,

Associate Consultant

Mariner, LLC

http://breaking-bi.blogspot.com

• ###### 7. Re: How to find how I am delivering my orders X% of the time

Is there any chance you can port this file to V7? I was not able to upgrade to 8 yet

Thanks,

Marcelo.

• ###### 8. Re: How to find how I am delivering my orders X% of the time

Marcelo,

I'm not sure how to downgrade the workbook.  So, I will post some screenshots so that you can recreate in v7.

SHEET 1: Determines what proportion of orders are under a certain number of days.

SHEET 2:  Determines the number of days for which a certain proportion of orders are under.

Hope this helps,

Associate Consultant

Mariner, LLC