Reporting against point in time data

[Kiera Mears]

Hello,

When running reports on the types of users that raise tickets, e.g. reporting against their department, job title, location, etc., it shows the department that user is currently in, not what they were in at the time of logging the ticket.  For example, if I logged a ticket last year when I was in Accounts but have since moved to IT, in the report it would say that someone in IT raised the ticket, because my user record would've updated. (Reporting against the 'Requester > Department').

How can we report but have it as a point in time rather than current? My initial thought was adding more fields to the ticket form but that seems messy - Are there any simpler solutions?

[Shishir · Accepted solution]

without adding any new field if you want to pursue this, one possible option can be Performance Analytics, where you setup your reporting needs. 

PA takes the snapshot of the data at that point in time. Whether you can use PA would completely depend on your use case.