Hello @HeatherDee -- you will have to use Data Designer for a report like this -- because you are building the report on the User Login History table which sits “underneath” the Users table, the only pathway up to the User table when building a report is through one of the User Login rows - so if they’ve never logged in, there’s no way to get up to that User’s record in the User table.

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

FYI @HeatherDee -- popped back into my above reply and corrected the link I gave you (original link I used was from a session last week!).

Scott

Moving this amazing discussion to the associated category.

Hi @HeatherDee ,

Build a report using the User Login History

On the Show Me Section:

1. Drop the Log ID field and change it to Count of Log ID

On the Group By Section:

1. Drop the Login Time and make it choose the aggregation (Day, week, month, or other timeframe) and then enable the Pivot 
2. Drop the CSM name

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 

HI SaifSN!

This is great! Thank you so much!

You’re welcome @HeatherDee.