We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

How to get the COUNT total

Received Response
52
Views
1
Comments
edited Mar 4, 2019 7:37PM in Reporting & Analytics for B2C Service 1 comment

Summary

I need information on how to use the COUNT function in an IF condition

Content

 

Hello, I tell you that I have a column called "Interactions Arrived" that displays every interaction, count (distinct inc_perfomance.i_id).
Then I have another column called "Managed", which should show the total of arrivals "count (distinct inc_perfomance.i_id)" but must also
be Canceled or Solved "incidents.status_id = 2 | incidents.status_id = 102" and that be resolved in 24 hrs.
I understand that there is a default report that can be filled, "Trend by Queue".
I would like to know how I can calculate the "Managed".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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