Hello,
I need to find the total number of calls performed by person by week in GI. I have added the following fields in grouping. Is Count the right function to be using?
Solved
How to calculate total activity by owner by week in GI
Best answer by Laura02
Hi,
I think you want to Count the NoteId identifier, not Sum it, to arrive at # of Call Activities per employee per week.
There is a field that records Week # in Timecard Activities.
Laura
1 person likes this
+19Hello,
To count # of calls by Owner by Week, I think you need to
- Group by Week, then Owner and
- Sum on the Key field for an Activity, which I think is the Note ID.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
Also, when you say group by Week, do you mean under the grouping tab or with functions? I don’t see Week as an option.
Thanks!
+19Hi,
I think you want to Count the NoteId identifier, not Sum it, to arrive at # of Call Activities per employee per week.
There is a field that records Week # in Timecard Activities.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.