Forum Discussion
Duration between Incident Status
Greetings, everyone!
I need help creating a visualization. Basically I have 3 tables:
Status
| ID | Status |
| 1 | Open |
| 2 | In Progress |
| 3 | Closed |
Incidents
| ID | Responsible | Status |
| 1 | Alice | Open |
| 2 | Bob | In Progress |
| 3 | Charlie | Closed |
| 4 | Charlie | Open |
And I have another table that saves the Start and End date of an ID in the Status, and calculates the duration that the ID stayed in that Status. If the End date is blank, the current day is taken into account, with exception of the "Closed" status wich does not have an End date by default.
Status Dates
| ID | Status | Start | End | Duration |
| 1 | Open | 01/06/2025 | 3 | |
| 2 | Open | 25/05/2025 | 03/06/2025 | 7 |
| 2 | In Progress | 03/06/2025 | 2 | |
| 3 | Open | 25/05/2025 | 29/05/2025 | 4 |
| 3 | In Progress | 29/05/2025 | 04/06/2025 | 5 |
| 3 | Closed | 04/06/2025 | ||
| 4 | Open | 02/06/2025 | 3 |
Both Status Dates and Status tables are related to the Incidents table via the ID column.
How can I create a Matrix that will tell me how many incidents each person responsible has, by Status, but also showing the average duration of the incidents?
| Open | In Progress | Closed | ||||
| Total | Avg Days | Total | Avg Days | Total | Avg Days | |
| Alice | 1 | 3 | 0 | 0 | 0 | 0 |
| Bob | 0 | 7 | 1 | 2 | 0 | 0 |
| Charlie | 1 | 4 | 0 | 5 | 1 | 0 |
Btw, If anyone has suggestions for better visualization, I'm totally open to discussion.
Best Regards,
Anonymous
pls see if this is what you want
4 Replies
Anonymous
pls see if this is what you want
Hi Anonymous ,
I wanted to follow up and see if you’ve had a chance to review the information provided by ryan_mayu .
If any of the responses helped solve your issue, please consider marking it "Accept as Solution" and giving it a 'Kudos' to help others easily find it.
Let me know if you have any further questions!Hello Anonymous , Just getting back to see if the shared details answered your question. If so, marking it as "Accept as Solution" and giving a 'Kudos' would be greatly appreciated to guide others in the community. Feel free to reach out with any additional questions!
Hi Anonymous , I hope you're doing well! Just checking in to see if you had a chance to review the details shared earlier. If any of the information addressed your needs, feel free to mark it as "Accept as Solution" to help others in the community. Please let me know if you have any further questions!