Question

3
Replies
1863
Views
Close popover
Sudheer Cherukuri (SudheerC2995)
AIG

AIG
US
SudheerC2995 Member since 2015 4 posts
AIG
Posted: May 31, 2016
Last activity: September 7, 2017
Closed
Solved

How to calculate Usage Summary using data from pr_daily_usage table

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.

UsageStat-Numbers.png

Message was edited by: Marissa Rogers - Added Category

Case Management
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.