4 Replies Latest reply on Feb 15, 2011 4:22 AM by jasoncadman

    Query results show 1 incident but a count of 2

    Rookie

      I've figured out that when running a query for, say, ticket counts by location, the results I get will show a count of say, 2, for that location, but when you expand the group, it shows 1 incident.  That's due to having 2 assignments on that 1 incident (due to re-assigning or whatever).  Is there a way to show a count of 1 incident per incident and not a count of 2 incidents that should only be one? Confused.....