I am trying to build a report that shows all users within a specific User Group and include the # of times they’ve logged in within the last 30 days.
I was able to build a report that shows the total # of times a user has logged in, but cannot figure out how to show users who have NOT logged in. Hence why I want to see the full user group in the same report.
Best answer by SaifSN
Hi
Build a report using the User Login History
On the Show Me Section:
On the Group By Section:
On the Filters use:
User (Lookup)→ License Type as Full
User (Lookup)→ Active = Yes
Status Not Equal to Failure
Login Time Equals Last N Days (Enter 30 on the Value box)
Lastly, change the visualization to Heat Map
+3Hello
With Data Designer, you grab a list of all the Users you want to report on, grab the list of “Login Counts by User” with another query, then merge them together so you retain the full list of users whether or not they’ve logged in.
If you haven’t used Data Designer yet, you can jump on Admin Office Hours -- next session is tomorrow here:
And if you can’t make that session, we post all upcoming sessions the day before on that same channel.
Hope that helps!
Scott Drost
Gainsight CSA
+3FYI
Scott
+6Moving this amazing discussion to the associated category.
Hi
Build a report using the User Login History
On the Show Me Section:
On the Group By Section:
On the Filters use:
User (Lookup)→ License Type as Full
User (Lookup)→ Active = Yes
Status Not Equal to Failure
Login Time Equals Last N Days (Enter 30 on the Value box)
Lastly, change the visualization to Heat Map
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
