Hey Guys,
Looking for some help here - I havent been able to find a solution anywhere.
I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those tickets are outside of SLA. Currently when I try to add that data point, it shows up on every column, but I just want it to show at the end of the matrix (the last column).
Example: This is what I want to see.....
<tbody>
</tbody>
Example: This is what I get currently get when trying to build the matrix (not what I want)
<tbody>
</tbody>
Does anyone know of a way to build the matrix as I'm intending it to look?
Thanks!
Looking for some help here - I havent been able to find a solution anywhere.
I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those tickets are outside of SLA. Currently when I try to add that data point, it shows up on every column, but I just want it to show at the end of the matrix (the last column).
Example: This is what I want to see.....
Client: | 0 Days | 1 Day | 2 Days | 3 days | 4 days | 5 days | SLA # of Days |
A | 30 tickets | 20 tickets | 16 Tickets | 10 Tickets | 6 Tickets | 3 Tickets | 4 days |
B | 25 Tickets | 18 tickets | 12 tickets | 8 Tickets | 0 | 0 | 2 days |
<tbody>
</tbody>
Example: This is what I get currently get when trying to build the matrix (not what I want)
Client | 0 Days | SLA # of Days | 1 Day | SLA # of Days | 2 Day | SLA # of Days | 3 Days | SLA # of Days | 4 Days | SLA # of Days | 5 Days | SLA # of Days |
A | 30 Tickets | 4 days | 20 tickets | 4 days | 16 Tickets | 4 days | 10 Tickets | 4 days | 6 Tickets | 4 days | 3 Tickets | 4 days |
B | 25 Tickets | 2 days | 18 Tickets | 2 days | 12 tickets | 2 days | 8 Tickets | 2 days | 0 | 2 days | 0 | 2 days |
<tbody>
</tbody>
Does anyone know of a way to build the matrix as I'm intending it to look?
Thanks!