Unique Users During Date Range (Cognos)
Posted on 2009-04-27
I have a report I'm trying to make in Cognos 8.2 that I'm having trouble with.
I need to count how many patients visit our clinics during a period of time. I don't need to know home many visits they have had, just the unique patients.
Because I'm filtering during periods of time, I'm getting duplication of patient id's for those patients seen more than once during that period of time. I need something to behave like a SQL "First", "Last", "MAX" or the like to just give me unique patients. Right now I can't accurately count the number of patient id's to get a unique list because of this duplication.