i have following Situation. I have a table withe TicketID field and these Tickets can have a Status from 10 to 60 and each of the statuses have a completion date. For the statuses itself its not necessary that the statuses gets upgraded in chronological order, that means for example if a Ticket ist rejected it can go from status 10 directly to status 40 without hitting other statuses.
The problem i have is to visualize the running balances using a line chart. I wann to see how many Tickets were in each status in each month without acumulating the values. With the the given table for example in January I have 8 Tickets wich were created in Jan.20 altough some ticketsStatus changed by now. For Feb.20 I need the value of 5 Tickets because back in Feb.20 these Tickets were in Status20. An so on for my whole dateset.
I have really now Idea how to beginn with. Thank you all in advance for any Help