By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,196 Members | 973 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,196 IT Pros & Developers. It's quick & easy.

Not Sure Which Analytic To Use

P: n/a
I have to count a bunch of calls into the service area by provider and
create a report of the "lower quartile(maybe list the lowest 25%)"

I tried NTILE but since I'm ordering by a COUNT exression, and many
providers have the same count, I'm seeing the same counts across
different quartiles. According to the docs, this is standard behaviour.

I also tried using PERCENT_RANK, but it gives results in the range of 0
to 1. I'm not sure how to evaluate the results to give me what I need.
Any suggestions ?

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.