Calculate average of daily active users in creatio for a time period

Hello 

To calculate daily average of users which started the session you could make a query based on SysUserSession. 

For example: 

SELECT AVG(DailyUsers) AS AverageDailyUsers
FROM (
SELECT
CAST("CreatedOn" AS date) AS Day,
COUNT(DISTINCT "SysUserId") AS DailyUsers
FROM "SysUserSession"
WHERE "CreatedOn" >= '2025-03-25'
AND "CreatedOn" < '2025-05-07'
GROUP BY CAST("CreatedOn" AS date)
) x;

Additionally you can create dashboard on User Session object to count Avarage of session for specific period. 

Hope this helps. have a nice day! 

I want to filter this data by Business Unit and Branch to which the user is associated. How can i achieve that?