4 Replies Latest reply on Sep 12, 2018 2:53 AM by Orlin Vladikov

# Counting the number of days a user has logged in in a Month

Hi team,

Below is a sample of my data. I am trying to figure out the number of days that a user has logged in into the system within a given month.

123abc

8/03/2018 10:00:21 AM

345def8/12/2018 12:20:00 PM
345efg8/21/2018 8:36:21 PM
345ghi8/21/2018 9:36:21 PM

So, essentially the expected result for August is:

User 123 logged in only on 1 day

User 345 logged in on 2 days

Any help will be greatly appreciated! Thanks!

• ###### 1. Re: Counting the number of days a user has logged in in a Month

Hi, Orlin

Try this calculation

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Counting the number of days a user has logged in in a Month

Hi,

Drag the [Login Time] date field at month year DATEPART in column shelf and use any of below calculated field on label

Hope this will help.

Mahfooj

1 of 1 people found this helpful
• ###### 3. Re: Counting the number of days a user has logged in in a Month

Thank you very much for the quick reaction! All sorted now!

• ###### 4. Re: Counting the number of days a user has logged in in a Month

Thank you very much for the quick reaction! All sorted now!

1 of 1 people found this helpful