You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Counting unique values

Received Response
29
Views
1
Comments
edited Sep 14, 2016 9:53AM in Reporting & Analytics for B2C Service 1 comment

Content

Hi all,

I'm attempting to make a report which will indicate if advisors are creating incidents in quick succession. We have an issue with some advisors forgetting to create an incident for phone calls, and then creating several for ones they didn't log earlier in the day.

The solution that my predecessor set up was to make a report with a roll up for each advisor name, and a column with the following expression

concat(date_format(incidents.created,'HH24:MI'), if(date_format(incidents.created,'MM') < '','',''))

Followed by a count(*)

This makes a list of times rounded to the minute, and shows how many incidents were created in that 60 second interval by the advisor being rolled up on. It kind of does what it's meant to do, but it's not really a good solution

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!