In HubSpot reports, we frequently compare different date ranges, such as “this year versus last year.” A common issue arises because some users may no longer be active within the company - which can be resolved by deactivating them but keeping them part of the team.
However, there are times when we only want to view current or recent data.
For year-over-year comparisons, we need to include data from deactivated users to ensure historical accuracy. Conversely, when examining recent data, we prefer to exclude deactivated users from these visualizations.
Currently, HubSpot provides only two practical options:
Manually select individual active users, which is labor-intensive and requires frequent updates to the report whenever team composition changes.
Apply a filter to display users only if they have associated data. Unfortunately, this option unintentionally removes active users who simply lack data for the selected timeframe.
To address this, we propose adding a new filter option on reports labeled “Include deactivated users?”. By default, this filter should be set to “off,” providing a convenient and efficient way to toggle inclusion or exclusion of deactivated users, simplifying both recent data analysis and historical comparisons.