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 

[AbdurRahmanSnow]

Hi @AndersBGS . Good evening.!
Thank you for the valuable reply. But I think, your solution is more towards "

Average RESOLUTION time", instead of "Average age of open tickets"?

Can you please guide me, if I am confusing?
I have 2 different scenarios:
- 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

[AndersBGS]

Hi @AbdurRahmanSnow 

Yes, you're absolutely right - if you're looking for the average age, then you need a PA script as you don't have a defined end time other than open till "current time"

[AbdurRahmanSnow]

Hi @AndersBGS . 
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.

Will you please provide the logic of the 2 automated indicator PA scripts? 

Please help me out. I would be very grateful to you.