The User tab in Dashboard provides detailed metrics related to individual user activity.
It allows you to analyze how users interact with different Assistants / Agents, track usage patterns, and identify key contributors based on request volume and cost.
This specific tab is automatically filtered by the Organization and Project selected.
Note that the filters by date range are independent in each tab.
The metrics provided in the User tab include:
- Total Active Users: This is obtained by running a select count distinct on the requests table; more specifically, on the "RequestUserId" field. This provides an accurate total of active users in the system.
- Average Cost by User (USD): Calculate the average cost incurred by each user.
- Average Requests by User: Provide the average number of questions or interactions of each user with the various Agents.
- Top Ten Users by Cost (USD): Identify and display the top ten users with the highest costs, considering the possibility that "RequestUserId" may be null.
- Top Ten Users by Request: List the ten users with the highest number of requests, even considering that "RequestUserId" may be null.
- Timeline with Average Cost by User and Date: Display the time evolution of the average cost per user.
- Timeline with Average Requests by User and Date: Display the temporal variation in the average number of requests per user.
- Pivot Activity by Users: Provide a detailed breakdown by UserId, Agent, Provider, Model, Cost, number of Requests and Total Tokens.