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