Solved

Time Summary using percentile P=90

Posted on 2010-11-27
2
522 Views
Last Modified: 2012-06-27
I am trying to determine the 90 percentile for time summary, it appears using the selection for Percentile that the summary seems to be higher than expected, I want to be sure that i am using this correctly. I first calculated the time difference shown below, then summarized it using the 90th percentile in the summary selection. Any help would be appreciated. Thanks

({@Enroute Time}-{@Dispatch Time})*1440


Screen Shot of 90 Percentile Summary
Screenshot of summary selection
0
Comment
Question by:srodgers45
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 34223552
When I add the counts i get 3960 not 4024.  Where are the missing 84?

It seems you are doing it correctly.

mlmcc
0
 

Author Comment

by:srodgers45
ID: 34223847
The time summary counts have some items excluded based on criteria, the overall do not. i have a disclaimer in the report explaining this. thanks for the help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question