#1
|
|||
|
|||
Ageing Analysis
Dear Mentors ,
In my attached sheet I am trying to do ageing analysis. Please help me to get result under mentioned bucket in the sheet. also month wise aiming to get when was the incident open and close and average of incidents raised every month. please help me to get the result. Maddy |
#2
|
|||
|
|||
It was unclear what you exactly did want (average number of incidents opened in given month equals with the number of incidents in this month ), but maybe you get some ideas.
|
#3
|
|||
|
|||
Thanks for replying.
ageing wise for Open cases 1.how many are under 0-30 days , 31-60 days , 61-90 days and >90 days. ageing wise for Closed cases - how long it took to close the incident. how many are under 0-30 days , 31-60 days , 61-90 days and >90 days ( took to close). Average number of incident raised every month. Is there any way to identify or mention or count the common description among all. Thanks Maddy |
#4
|
|||
|
|||
in addition to my previous comment , pls help me how can I get the sum of 0-30 days and so on the basis of Priority( like sum of incident in 0-30 days for P3)
would be waiting for response |
#5
|
||||
|
||||
See attached where:
|
#6
|
|||
|
|||
hello Sir,
have you attached the file? |
#7
|
||||
|
||||
|
#8
|
|||
|
|||
thanks sir !!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Comparison Analysis | maddy29 | Excel | 9 | 05-31-2022 07:23 AM |
Attendance Analysis | LarryLee87 | Excel Programming | 4 | 11-23-2016 05:14 PM |
Analysis in Excel with chart | Aseren | Excel | 6 | 02-24-2016 06:42 AM |
What if Analysis | fm2406 | Excel | 0 | 10-20-2015 09:47 AM |
Delay Analysis | ketanco | Project | 3 | 03-15-2013 01:06 PM |