Why doesn't my user COUNT() in History explore match total existing users? (System Activity)

[LookerExperts]

Knowledge Drop

Last tested: Nov 7, 2020
 

The History explore in System Activity is NOT the best place to see ALL users, looks, dashboards on the instance. The reason for this, is because History only tracks query events, so if a user has not done anything in 90 days, or a look or dashboard has not been queried in 90 days, it will not show up in History.

For all of your content exploration needs, use the following explores:

/explore/system__activity/look
/explore/system__activity/dashboard
/explore/system__activity/user

For more details on the History explore, see our documentation on the History Explore in System Activity.

This content is subject to limited support.