Why is my count coming out wrong?
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.