sys_history_line returning duplicate rows and inflating ticket numbers when using single score

[marsdendev]

Hello,

I am building a report showing when a team updated/worked a ticket last week. Currently the report is showing duplicate rows and inflating team numbers because the tech had to update the ticket several times before they sent it onto another team or resolved it. (Please note using Aggregation: distinct count is not working for me because it removes any rows with a duplicate ticket so the count is lower than it should be.)

Report specifics-

Data Table: History [sys_history_line]

Aggregation: Count

Type: Single Score

All these filter conditions must be met

Update time on Last week

Old is   "Assignment group"

or New is "Assignment group"

Appreciate the Help

[marsdendev · Accepted solution]

I found the solution it was way simpler than I thought it would be. I used dot walking aka relative fields and switched it to count distinct.

Report specifics-

Data Table: History [sys_history_line]

Aggregation: Count Distinct

Type: Bar

All these filter conditions must be met

Update time on Last week

User.Manager is "Assignment group manager"

Tested and vetted and the processing time is super short as well.