I have data that is a log of tickets, timestamps, and usernames where a certain event has taken place. We want to see details of when the event has occurred more than once on a ticket. The raw data contains a row for each time the event occurred, including the ticket ID and timestamp. In this example I have a ticket that appears twice in the logs, since the event occurred twice.
I have what I will call a "reference" matrix to display the Ticket ID and Count of Ticket ID - this correctly identifies the ticket ID and a "2" in count, as expected.
However, I have "detail" matrix below it which I want to display all the rows of the selected Ticket in the log (2 instances), when the Ticket IDs in the reference is clicked. When clicking a ticket in the reference matrix, the detail matrix is only showing one row, despite there being two records for this one ticket.
Here is an example of my visuals:
Reference Matrix:
Ticket ID, Count of Event (2)
Detail Matrix:
Ticket ID, Timestamp (earliest), Other data
I want this result:
Reference Matrix:
Ticket ID, Count of Event (2)
Detail Matrix:
Ticket ID, Timestamp (earliest), Other data
Ticket ID, Timestamp (next earliest), Other data
