i need to Calculate the average days the tickets have been open in the past 30 days from a specific number which is on sheet issue tracker chart B8.
When i change that date i need the formula to calculate + 30 days from that date then average it.
I tried make a table to get the individual number from each day then average it that way but i couldn't do that either.
Any help or advice would be appreciated.
UPDATED INCLUDES SPREEDSHEET ATATCHMENT
Last edited by Reece_Norman; 08-10-2022 at 05:59 AM.
I would like to be a little more rigorous about what you are trying to calculate
the average days the tickets have been open in the past 30 days
- Look at each day starting at the start date in B8, and add the number days that all tickets that are open on that day have been open, and do this for all days, and take the average
- Look at each ticket that was either still open as of 30 days after the start date, or was closed in the 30 days after the start date, and average the number of days each of those tickets has been open as of 30 days after the start date.
- Something else
What are you trying to measure with this number? The effectiveness of closing tickets?
[*]Look at each day starting at the start date in B8, and add the number days that all tickets that are open on that day have been open, and do this for all days, and take the average
Yes this is what i am after , to include all tickets even ones that have been closed so i can get a over all average on how long its taken maintenance to fix the issues in a given 30 day period.
like columns P:Q ?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
i should be able to get what im looking for from that thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks