Solved

Time Summary using percentile P=90

Posted on 2010-11-27
2
530 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 101

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

717 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