How to calculate average age of open tickets?

[Aayushi]

Hi guys,

I need help in finding out the average age of open tickets.

It is basically the network days from created to last reported day.

Last reported day is the last day in the reported period. E.g. report from jan 1 to aug 31, then last reported day is 8/31. Today is 9/12, so if the ticket was resolved e.g. on 9/6, then it was open on 8/31, so it counts as open on the last day reported day (8/31) and age is network days from create date to 8/31.

It is quite urgent for me and any help would be appreciated.

Thanks!

[Aayushi]

Hi @v-yanjiang-msft 

Thank you for replying.

To me, it doesn't sound this easy.

It is not the age of open tickets at the end of each month.

It is the age of open tickets at Key date. 

Key Date would be the date entered by the user.

[v-yanjiang-msft]

Hi @Aayushi ,

According to your description, I create a sample.

In my understanding, you want to calculated the average days of each report period, here's my solution.

Create a measure.

Average age =
AVERAGEX ( 'Table', DATEDIFF ( 'Table'[OpenDay], 'Table'[ResolvedDay], DAY ) )

Get the correct result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.