+ Start a Discussion
bvcbvc 

"%Users logged in 1st time"

Hi,
 How generate report on first time logged users in salesforce.it's very urgent any one please assist.

Thanks Advance:)

Regards,
Venu
Amit Chaudhary 8Amit Chaudhary 8
you want to create a Summary or Matrix Report and select
Category: Administration Reports
Report Type: Users 
The field you want to summarize is located in the User Login History section: Login Date. 

There are a few things that you want to be careful of, if you only want the count of times they Logged into Salesforce.com then you want to filter the User Login History.ClientType to count only Browser and Mobile logins so that you don't count MS-Outook synchronization or other clients.
https://success.salesforce.com/answers?id=90630000000gsJjAAI
https://help.salesforce.com/HTViewHelpDoc?id=users_login_history.htm&language=en_US (https://help.salesforce.com/HTViewHelpDoc?id=users_login_history.htm&language=en_US)
https://success.salesforce.com/answers?id=90630000000gtQ9AAI

Please let us know if this will help u

Thanks
Amit Chaudhary
RajaMohanRajaMohan
Hi Venu,

You need to create a summary report on User object and give the criteria like below,

User-added image

The Logins (RowCount) is a formula field. Logins == 1 shows the 1st time login user. You can calculate the % based on that. 

Hope this helps.

Thanks,
Raja
 
bvcbvc
Hi Raja Mohan,

Thanks for quick reply.i put custom forula is RowCount.
but what is login==1 that is condition please help on...


Regards,
Venu
RajaMohanRajaMohan
Hi Venu,

You need to create another formula field which sum's the Logins==1, this will give you the total. This will help you in calculating the %.

Thanks,
Raja
bvcbvc
Hi RajaMohan,

where i create another formula field.here no logins field in user object.can you please explain clearly with screen shot.

Regards,
Venu
Niels MuysewinkelNiels Muysewinkel
Did you solve this?