How to create these 2 Indicators for Performance Analytics? Average time and Average age

[AbdurRahmanSnow]

Good morning.!
I have requirement to create 2 indicators for Performance Analytics? We already have average time to resolution in our Dashboard/Report. We also want the below.

Requirement:
- Average time tickets stay unassigned as they enter my group. (before someone assigns to someone)
- Average age of open ticket ("how long has this ticket stayed open for?") i.e. days / hours / months

Please help.
@Ankur Bawiskar @Dr Atul G- LNG @Viraj Hudlikar 

[AndersBGS]

Hi @AbdurRahmanSnow ,

1st requirement: - Average time tickets stay unassigned as they enter my group. (before someone assigns to someone). Here you need the count and the sum of time a ticket stays unassigned.

2nd requirement: 

- Average age of open ticket ("how long has this ticket stayed open for?") i.e. days / hours / months. Here you need again the sum of open and the count of tickets. 

Based on the two above, you can create 2 different formula indicators to do the calculation.

[Dr Atul G- LNG]

Hi @AbdurRahmanSnow 

Follow @AndersBGS inputs.

[AbdurRahmanSnow]

Hi @AndersBGS . Hope you are fine and good.!
Thanks a lot for your valuable reply.

Sorry, I am still struggling to create the Formula indicator for both of these requirements and failed multiple times. I found an OOB formula indicator for average age of open incidents, but it only calculates the current open tickets, and not the historical tickets too..., and is also not accurate.
Please help me out. I would be very grateful to you.

Will you please provide the 2 automated indicator PA scripts? 
Thank you.

[AndersBGS]

Hi @AbdurRahmanSnow 

Why do you need PA scripts? Basic filtration should be based on the indicator source where 1 automated indicator is sum of resolved time and the other is count if tickets. Afterwards just do a sum / count = average resolution time.