Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Why is my count coming out wrong?

edited Aug 17, 2017 12:26AM in Reporting & Analytics for B2C Service 5 comments

Content

I have a dashboard that i am creating and I am trying to create and Standard Report with Chart

This if for a team that calls our customer before we have a scheduled technician visit.  We track the following:

1. How many completed calls they made.

2. How many they attempted to call but did not get a response (RNA).

3. How many changes were made that did not prevent a wasted dispatch.

4. How many wasted dispatches were prevented.

 

My problem is with # 3.  This expression needs to count how many different incidents they worked on that had any 1 of 6 different changes made but it did NOT result is saving a wasted dispatch.  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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