Forum Discussion

angelompcunha's avatar
angelompcunha
Frequent Visitor
5 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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.