Calculation total days count

[selvakumarsr]

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))

[sunny_talwar · Accepted solution]

May be try this

Count(DISTINCT Floor(CIN_TIME))

or

Count(DISTINCT Floor(Login_DATE))