13 Replies Latest reply on Feb 13, 2019 11:44 AM by Kumar Garikapati

# help on calculation  for to count number of open issues between period of time

Hello

I have a table with a issues  with a Start Date and status change. i need to calculate how many issues are opened ,closed for particular period and how many were total issues for that rage of dates. how can i represent it in the with monthly change ,quarter change and year over year diff. i am attaching following screen to understand more.

thanks for help

open issues till 1/1/2011 -. 12 issues i.e  issues which were opened till 2011.

in the period 1/1/11- 1/1/12  there were 4 new issues were  found in that period and 7 issues were closed  . total open issues are 9(12+4-7)

1/1/12-1/1/13  there 6 issues were newly opened and  1 issue was closed  9(issues opened till last period)+6-1 please see attached for the screen shots.

attache the mock up workbook Message was edited by: Kumar Garikapati

• ###### 1. Re: help on calculation  for to count number of open issues between period of time

Could you please attach mocked up sample data as twbx.

Thanks,

Shin

• ###### 3. Re: help on calculation  for to count number of open issues between period of time

Not exactly sure about one year shifting from your picture, but something like this?

Thanks,

Shin

• ###### 4. Re: help on calculation  for to count number of open issues between period of time

thanks. but i need see for particular period of time. i want to see between august 2011 to jan 2013

• ###### 5. Re: help on calculation  for to count number of open issues between period of time

 Period Period BOP EOP Start End Pending Opened Closed Pending 1/1/2010 1/1/2011 0 12 0 12 1/1/2011 1/1/2012 12 4 7 9 1/1/2012 1/1/2013 9 6 1 14 1/1/2013 1/1/2014 14 4 8 10 1/1/2014 1/1/2015 10 0 4 6 1/1/2015 1/1/2016 6 0 2 4 1/1/2016 1/1/2017 4 0 3 1 1/1/2017 1/1/2018 1 0 1 0 1/1/2018 1/1/2019 0 0 0 0
• ###### 6. Re: help on calculation  for to count number of open issues between period of time

You mean this?

Thanks,

Shin

• ###### 7. Re: help on calculation  for to count number of open issues between period of time

thanks the answer is almost correct but used need to select the range of the dates they want to see.

• ###### 8. Re: help on calculation  for to count number of open issues between period of time

If this helped, please mark my answer as correct / helped not from inbox but from original post.

Thanks,

Shin

• ###### 9. Re: help on calculation  for to count number of open issues between period of time

Can you upload the work book

• ###### 10. Re: help on calculation  for to count number of open issues between period of time

thanks for your responsse Calculate tickets created, closed and open at month end

this is similar question i have

• ###### 11. Re: help on calculation  for to count number of open issues between period of time

File

• ###### 12. Re: help on calculation  for to count number of open issues between period of time

thanks for your time .i think numbers look great how can we create visual for this data for interactive to end user.

• ###### 13. Re: help on calculation  for to count number of open issues between period of time

awesome. what if i want to see in quaterly or monthly level