mtownbound
Technical User
I'm trying to chart averages from distinct entries grouped by technicians. Here is a sample:
Group Ticket# Time Spent
Tech A #87234 15
#88343 20
#88343 30
#88431 50
The formula field that I've created takes the distinct count of the trouble tickets so that the average is 38.33 instead of incorrectly couting the lines for an average of 28.75. The issue is that I can't chart that in a bar chart.
Any ideas?
Thanks!!
Group Ticket# Time Spent
Tech A #87234 15
#88343 20
#88343 30
#88431 50
The formula field that I've created takes the distinct count of the trouble tickets so that the average is 38.33 instead of incorrectly couting the lines for an average of 28.75. The issue is that I can't chart that in a bar chart.
Any ideas?
Thanks!!