
1. Re: How to find how I am delivering my orders X% of the time
Shawn Wallwork May 9, 2013 5:50 PM (in response to Marcelo Konatu)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
Marcelo Konatu May 10, 2013 6:03 AM (in response to Shawn Wallwork)Sorry about that. Here it goes the new file

Example of 90%.twbx.zip 1.0 MB


3. Re: How to find how I am delivering my orders X% of the time
Shawn Wallwork May 10, 2013 10:53 AM (in response to Marcelo Konatu)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.
Was this what you were looking for?
Shawn

4. Re: How to find how I am delivering my orders X% of the time
Marcelo Konatu May 10, 2013 11:51 AM (in response to Shawn Wallwork)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
Shawn Wallwork May 10, 2013 1:11 PM (in response to Marcelo Konatu)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
Brad Llewellyn May 10, 2013 1:38 PM (in response to Marcelo Konatu)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,
Brad Llewellyn
Associate Consultant
Mariner, LLC
brad.llewellyn@marinerusa.com

Example of 90%.twbx.zip 67.1 KB


7. Re: How to find how I am delivering my orders X% of the time
Marcelo Konatu May 13, 2013 6:48 AM (in response to Brad Llewellyn)Hi Brad,
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
Brad Llewellyn May 13, 2013 7:12 AM (in response to Marcelo Konatu)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,
Brad Llewellyn
Associate Consultant
Mariner, LLC
brad.llewellyn@marinerusa.com

9. Re: How to find how I am delivering my orders X% of the time
Marcelo Konatu May 13, 2013 11:30 AM (in response to Brad Llewellyn)Thanks Brad, that worked just fine. Great job!