Forum Discussion
Solved
Difficulties with Active and Inactive Relationships
I'm attempting to build a dashboard that will show, among other stuff, the volume of trouble tickets created and closed by the team. I have 2 tables, one for tickets created ( Raised Table) and ano...
The first thing I would do is to combine the Raised and Resolved tables into a single ticket lifecycle table. Then you would remove the ambiguity. Keep the date and time tables linked to the date and timestamp in the lifecycle table.
That's what I've done. Since I merged those 2 tables now I've run into the problem of relating the Created Date and the Resolved Date but I don't think there is any way around it other than using the USERLATIONSHIP function. I think I must compromise between relating the Incident ID or the date