Hello, I hope some can help me, i have a data table with this columns
- Ticket creation date
- Last action
- Date/time of last action
Actions can be things like giving a priority to the ticket or give a solution to the customer. For every action in a ticket a new table row is created.
I want to create something that shows me the average time between the giving a priority to a ticket action and the first action that follows on giving a priority to a ticket. The difficulty is that the action that follows on giving a priority to a ticket varies.
@AIB Yes i mean exactly what you are saying. With giving a priority to a ticket i indeed mean the action set priority to regular in the example table. And i indeed want the time between when 'Action' is set to "Set priority to regular" and whatever comes immediately afterwards that for a specific ticket ID. I want to give you all the sample data that you need, but i don't know what data you want extra besides the example table that i allready posted above.
Yes exactly, something like this: - Ticket A took 5 minutes between the set priority and following action - Ticket B took 3 minutes between the set priority and following action - Ticket C took 15 minutes between the set priority and following action The average has to be the average of 5, 3 and 15 minutes Many thanks for your help.
This looks great and when i use it on a card visual i get data. The only doubt i have is, does this use the rows with "set priority to" as start date/time? Maybe it's my beginner knowledge of PowerBI but i don't understand how this measure does that.
Sorry, you're right. I misread and was taking the creation time as initial time. This is the updated version. As you see you can use this pattern with minor variations to extract the time period you are interested in.