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

Calculate percentage for responses received on the same day of incident creation

edited Feb 28, 2020 1:57PM in Reporting & Analytics for B2C Service 1 comment

Summary

Calculate percentage for responses received on the same day of incident creation

Content

Hi,

I have a requirement that I must calculate no of incidents that receive response on that day itself, if there are multiple response  I should consider one response only

For example

Total no of incident created today is 6

4 incidents receives single response  = 4

1 incident no response                     = 0

1 incident 3 responses                      = 1

 Total                                              = 5          

Report

Total Incident

No of response

Percentage

6

5

83.33

Table to join incident &  Thread

How do I achieve this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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