"Snapshot" reporting on a daily basis
I am importing a list of tickets on a daily basis and generating daily reporting based on the data in those tickets (ie, how many tickets in a specific status, etc). The Key field is the ticket#, not ...
Forum Discussion
Jamie,
I do this with a child table that holds the status of the parent and the date time stamp of that status.
Ticket << Ticket Status >> Status
Your report is now run against the Ticket Status table instead of the Ticket table. So if Ticket #1 goes "New", "Assigned", "Scheduled", "Complete" it will have four records in the Ticket Status Table with the dates of their changes.
------------------------------
Don Larson
------------------------------
I do this with a child table that holds the status of the parent and the date time stamp of that status.
Ticket << Ticket Status >> Status
Your report is now run against the Ticket Status table instead of the Ticket table. So if Ticket #1 goes "New", "Assigned", "Scheduled", "Complete" it will have four records in the Ticket Status Table with the dates of their changes.
------------------------------
Don Larson
------------------------------