calculate time spent in each state

[Bu__]

i have a data as given below

Ticket num	Created	state
Ticket_1	11/3/2022 0:06	P4
Ticket_1	11/3/2022 0:18	P4
Ticket_1	11/3/2022 0:21	P3
Ticket_1	11/3/2022 0:22	P2
Ticket_1	11/3/2022 0:23	P1
Ticket_1	11/3/2022 0:24	P1
Ticket_1	11/3/2022 0:26	P1
Ticket_2	12/12/2022 13:40	P1
Ticket_2	12/12/2022 13:41	P1
Ticket_2	12/12/2022 13:43	P2
Ticket_2	12/12/2022 13:45	P2
Ticket_2	12/12/2022 13:45	P4
Ticket_2	12/12/2022 13:46	P3
Ticket_2	12/13/2022 14:00	P1

i would now like to calculate time spent by each state in hours/seconds for every ticket  in a 100% stacked bar chart

and see the transition for  state for Ticket_1 which changes from P4-->P3-->P2-->P1

Final chart to look something like this

[scee07]

Hi, 

my statement would be that a stacked bar visual cannot work and I would like to here from the communtiy if this statement is wrong or not. My reasoning is as follows:

I have done a little toy model similar to yours resuling in the following table:

The main observation is that I need an index or the timestamp to define the sequence of durations in percent. So, I have a value (the percentage) and three other dimensions (state, sequence and ticket id). 

The matrix visual can capture all dimensions as you can always put drilldown filelds in rows or colums. However the bar chart is one dimension short. You must put in the sequence to maintain the order and then you would have to put the state in the quick info. Which is clearly not what you want. As soonn as you put in the state for the category you loos the sequence and in this case all s1 values would be summed up per ticket, although in different phases. 

Perhaps somone know it better than me. At the moment my statement would that no standard visual can do what you want. 

I am curious to know if this is not the case. 

Best regards 

Christian