When measuring adoption it’s useful to see the number of logged in users for a given period as a percentage of the total user base. Since Salesforce reports can only report on what data is visible (as is to be expected) it’s not possible to compare logged in users to total users. There is a way around this by using a joined report.
- Create a joined report using User as the primary object. This will create a Users block.
- Drag a field from the Users object over to an empty space in the preview area. This will create a second Users block. It’s a good idea to use a field which is required for reporting purposes since the report will be grouped at this level.
- Filter the second block on logged-in users for the desired time frame.
- Create a cross-block formula field using the Record Count summary fields from each block to divide the number of logged in users from block 2 by the total number of users from block 1. This field will typically be called Logged In Percentage or something similar. Change the formula to field type to percentage.