Joined: 16 Dec 2010
Location: United States
Online Status: Offline
Posts: 20
Topic: Unique Counts Posted: 16 Dec 2010 at 7:46am
I'm new to crystal reports and I was trying to create a unique count. For example the records pull look like this:
Date ID Result
12/16/2010 11:15:48 123456 X
12/16/2010 13:24:32 123456 X
12/16/2010 15:17:18 354886 X
12/16/2010 18:48:55 123456 X
And I want to count the result when it equals X, but only the most recent result. So ideally I want the count for this data set to display "2" 1 for each ID. Is there a way to do this?
Joined: 16 Dec 2010
Location: United States
Online Status: Offline
Posts: 20
Posted: 16 Dec 2010 at 8:24am
Actually the the distinct count of ID when the result value = "X" if it's the most recent instance. So if the result is "Y" for a later Date, then "X" is not counted and "Y" is used instead.
Joined: 16 Dec 2010
Location: United States
Online Status: Offline
Posts: 20
Posted: 16 Dec 2010 at 8:47am
Yes the most recent instance defined by the maximum datetime per ID. X and Y are statuses that could vary from 12 different static entries or preset list of possibilities.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum