Calculate percentage for responses received on the same day of incident creation
Summary
Calculate percentage for responses received on the same day of incident creationContent
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?
Tagged:
0