For some reason Usage Summary data is showing zeros, so we want to know how to calculate data like "Regular Users","Occasional Users", "Service invocations" and "Web User Invocations".

Following is the sample data that I see in "pr_daily_usage" table when I execute below query.

SELECT pzInteractionCount,pzInvocationCount,pzMayCheckOutRules,pzModifiedRulesCount,pzNoInvocationFlowCount,pzNoInvocationUserCount,pzUserType,pzUsageDay,pzUsageHoursCount,

pzUserAdditionalInfo,pzUserId FROM pr_daily_usage WHERE pzUsageDay >= '2016-03-01' and pzUsageDay <= '2016-03-31';

In this data I see there are four unique values to "pzUserType" column

H --> users login through Browser
W --> has userID as "GUEST:noName"
A --> has UserID as "WEB"
S --> has UserID as "Service"

With this data present in "pr_daily_usage", how can I calculate "Regular Users","Occasional Users", "Service invocations" and "Web User Invocations".

Also what is the meaning of "pzInteractionCount", "pzInvocationCount", "pzNoInvocationFlowCount", "pzNoInvocationUserCount", I do not see any help or explanation related to these columns.

If anybody has any clue on this please respond. Thanks.

Message was edited by: Marissa Rogers - Added Category