Ask Search:
heather halliwellheather halliwell 

Exclude last log in date range in a report

I am trying to create a report that shows all users who have logged in and those who have not. I got that part down. What I need to do is exclude anyone who logged in from a certain time frame (ie. 11/1/2016-9/30/2018)  I tried doing a filter on Last Login but that obviously excluded my null login dates. Is this possible with a formula? (background we just launched our pilot 10/1 and I need to exclude anyone who logged in prior to launch and also need to show all active users who have not logged in) 
Best Answer chosen by heather halliwell
Steve MolisSteve Molis
Thanks for the screenshots, that's helpful.

Okay I'm thinking that you might need to use a Joined Report for this. 

I'm concerned that if we try to do this in a single Report we might run into some trouble with the filtering.  And you can't create a Report Bucket on a Date Field, and you can't reference the User Login History via a Formula Field, so we're kinda screwed there... actaully we're very screwed... Royally Screwed   

All Answers

Steve MolisSteve Molis
Hi Heather,

Could you post a screenshot of the Report, Report Type, and any Groupings, Settings, etc, that you're currently using and the results you're getting, and create a mock-up of what you would like your Report results to look like?  (for questions related to Reports and Dashboards those are really helpful)
heather halliwellheather halliwell
Hi Steve: Here is a snipit of info. The report is MUCH larger so I hid rows to just get the point across! What I need is the info in the red and green boxes and exclude the data in blue. Red=all the users who are Active and have not logged in. Green are the users who have logged in since we launched and the Blue are users who I want to exclude from this report-if possible. The exclude in the actual report covers a 12 month period. It's not noted but under Grouping: I have Last Login grouped by Month. Thanks for taking a look! 
User-added image
Steve MolisSteve Molis
Thanks for the screenshots, that's helpful.

Okay I'm thinking that you might need to use a Joined Report for this. 

I'm concerned that if we try to do this in a single Report we might run into some trouble with the filtering.  And you can't create a Report Bucket on a Date Field, and you can't reference the User Login History via a Formula Field, so we're kinda screwed there... actaully we're very screwed... Royally Screwed   
This was selected as the best answer
heather halliwellheather halliwell
HAHAHA!! I was thinking the Joined report was my only option here. Because it is still in Beta I am not allowed to use it. So super duper screwed! Really appreciate the help and second set of eyes. 
Steve MolisSteve Molis
Hmmmm...  what about separate Reports displayed side-by-side in a Dashboard?