Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In a day, there are multiple check in time for one user.
USERID | CIN_TIME |
16 | 4/2/2017 12:55:12 PM |
16 | 4/2/2017 12:57:21 PM |
28 | 4/2/2017 1:48:18 PM |
16 | 4/2/2017 3:05:48 PM |
28 | 4/2/2017 3:09:44 PM |
28 | 4/2/2017 7:47:00 PM |
16 | 4/3/2017 8:52:08 AM |
Now i need to calculate distinct count of days by user. For Example: USERID 16 total count should be 2 days and for USERID total is 1 day.
I tried something like this
Count(DISTINCT Aggr( Min(Date(Login_DATE)), Login_DATE))
May be try this
Count(DISTINCT Floor(CIN_TIME))
or
Count(DISTINCT Floor(Login_DATE))
May be try this
Count(DISTINCT Floor(CIN_TIME))
or
Count(DISTINCT Floor(Login_DATE))