COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: nfldbunker on 05 Aug 2009 06:34:25 AM

Title: Top 10 Report based on Diagnosis with associated LOS(Length of Stay)
Post by: nfldbunker on 05 Aug 2009 06:34:25 AM
HI Everyone

Just wondering how i would approach developing a report for the top 10 or 20 diagnosis and some associated data such as length of stay, procedure etc.

please provide some details if possible.

regards

nfldbunker

 
Title: Re: Top 10 Report based on Diagnosis with associated LOS(Length of Stay)
Post by: cschnu on 05 Aug 2009 10:35:22 AM
Quote from: nfldbunker on 05 Aug 2009 06:34:25 AM
HI Everyone

Just wondering how i would approach developing a report for the top 10 or 20 diagnosis and some associated data such as length of stay, procedure etc.

please provide some details if possible.

regards

nfldbunker
 
Not really sure what you are asking, my guess is you need to look into grouping your data and then limiting your query to 10 or 20 rows.