Im sorry for confusion.
I have four fields to use for this script.
3. Date Opened
4. Transferred Date.
Query 1: My dimension will be the Assignee, and im going to count the tickets transferred in first instance. Ticket number may have duplicates depends on how many times it was transferred.
Query 2: Same as with Query 1 but this time im going to get the second instance of transferred date.