Recent searches
No recent searches
HOW TO SHOW A DISTICT TICKET ID COUNT FOR A SUM NUMBER METRIC
Answered
Posted Aug 26, 2022
I cannot figure out how to create a report that will show the sum of a custom number field metric and only add tickets once not multiple time. The reports keep summing the same ticket ID multiple times so my sum is not accurate! In the photo - my calculated metric i am using to SUM is the last column - stops affected.
0
1
1 comment
Jacob the Moderator
Hi Kay!
Possibly you're creating your report in the Ticket Updates history dataset?
I would use the Tickets dataset for that - so what is counted isn't the number of updates, but the number of tickets.
0