Skip to main content
Question

Analytics > Users > Number of users

  • June 8, 2026
  • 1 reply
  • 15 views

danny.oneill
Forum|alt.badge.img+2

I’m wanting to build a dashboard that shows our various analytics for stakeholders and one I see in the portal under Analytics > Users is the estimated number of unique users who interacted with the workspace. How is this calculated? Ive tried to replicate the counts using various filters but can never get close.

 

Has anyone built any stakeholder analytics pages that can offer some suggestions.

1 reply

florine.vm
Community Manager
Forum|alt.badge.img+1
  • Community Manager
  • June 9, 2026

Hi Danny !

The estimated number of unique users who interacted with the workspace shown in Analytics > Users is the total count of distinct individuals, both authenticated and anonymous, who made at least one API call to your portal during the selected period.

 

The metric combines two independent counts, then sums them:

1. Authenticated users

- Source: the `ods-api-monitoring` internal dataset

- Filter: requests where `user_id` is not `anonymous` and `bot = False`

- Count: number of distinct `user_id` values over the period

 

2. Anonymous users

- Source: the `ods-api-monitoring` internal dataset

- Filter: requests where `user_id` is `anonymous` and `bot = False`

- Count: number of distinct IP addresses (`user_ip_addr`) over the period

 

Final value is : Total unique users = distinct authenticated user IDs + distinct anonymous IPs

 

 

The label "estimated" reflects a known limitation on the anonymous side:

- One IP ≠ one person: multiple users sharing the same network appear as a single anonymous user.

- One person ≠ one IP: a single user connecting from different networks or using a VPN may be counted multiple times.

 

You can retrieve this figure via API.

If you need to query this metric programmatically for a specific time range, it is available through the Explore API v2.1 on the `ods-api-monitoring` dataset, using `COUNT(DISTINCT user_id)` and `COUNT(DISTINCT user_ip_addr)` aggregations with a `timestamp` range filter.

 

Access to this dataset requires a user account with the correct permission on your workspace, which is typically held by workspace administrators.

 

I hope this helps!