Hello,
I ran into an issue while creating a Custom Report for tickets that:
1) Were created this year (works fine)
2) Ref. Ticket Number field is not empty
I selected the Advance Filter - Ref.Ticket Number 'is not' None
The report runs correctly for the first two to three pages but I see a lot of 'Not Assigned' (basically blank field) starting page four.
I also did an export to CSV to filter 'Not Assigned' tickets and got the result:
Out of 1387 tickets that showed on the report, 1150 odd were 'Not Assigned'. Please investigate and let me know how I could pull a clean report for tickets in which Ref. Ticket Number field is populated.
Thanks in advance!
Nikhil