Joined: 06 Nov 2019
Online Status: Offline
Posts: 13
Topic: Count Calls - Only Certain Times Posted: 23 Dec 2019 at 2:52am
I am trying to create a report that lists call natures and counts how many calls of each nature occur between certain times (i.e. midnight-1AM, 1AM-2AM, etc) between certain dates. I have my record select squared away, so I have a good set of data. I just need to be able to count calls between certain times of the day. I know I will need a running total and what field it will need to reset on, I'm just stuck on what the evaluation formula for this RT should be.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 23 Dec 2019 at 8:38am
First thing is if your data unduplicated?
If you need a summary you should not use a RT. Since it will reset itself you won't have any summary level data. I would consider just creating a formula to get the hour value from the time or datetime...hour(field)...and using it to group on or as part of a crosstab with a distinct count of the callid field.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
