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 count Number of incidents Created by Service mailbox and Ask a question

Accepted answer
23
Views
7
Comments
edited Jan 25, 2019 11:50AM in Reporting & Analytics for B2C Service 7 comments

Summary

How to count Number of incidents Created by Service mailbox and Ask a question

Content

i created a report to count how many incidents Created, Edited, Solved by agent per day, as i need historical data i am using transactions table to get this detail. 

problem :

incident created by Service Mailbox or Ask a question is not created by any agent so it is not coming under sum(if(transactions.trans_type= 2 & transactions.tbl=1, 1)), is there any way i can add them in this column under 'No value'

 

i am attaching xml of my report

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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