Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
COUNT on a COUNT — Cloud Customer Connect
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

COUNT on a COUNT

Accepted answer
34
Views
1
Comments
edited Mar 12, 2020 4:48PM in Reporting & Analytics for B2C Service 1 comment

Summary

Counting how many responses were sent on an incident.

Content

I am calculating how many (transactions.trans_type='8') "Response Sent" transactions are taken on tickets, to identify which ticket types have more responses than they should.

After I calculate how many responses were sent on each ticket, I want to COUNT how many tickets had that specific number of "Response Sent" transactions.

So I want to know how many tickets had 1 response sent, 5 responses sent, 10 responses sent, etc.

I'm able to identify how many responses were on a single ticket, but I'm not able to do a COUNT on the COUNT of responses of those tickets. Anyone have any ideas?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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