Calculation total days count

selvakumarsr — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In a day, there are multiple check in time for one user.

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

Re: Calculation total days count

sunny_talwar — Wed, 26 Apr 2017 12:46:08 GMT

May be try this

Count(DISTINCT Floor(CIN_TIME))

Count(DISTINCT Floor(Login_DATE))