In-Progess tracker: Current count and month to month historical number

I am currently working on an Activity progress tracker (unable to post a picture due to sensitive info). I have figured out how to track a number for the current month for most items, however, I need to be able to do 2 things. 1: track the current month (live) In-Progess items, and 2: create a historical log of these items that are In-Progess at the end of each month. This data-set is specifically for a graph to have an accurate visual track of where our activity progress and carryover is from month-to-month.

I can track current numbers from a COUNTIF function for that status item, and know how to track current month and historical based on a date column tracking each specific type, however, In-Progess does not have a date outside of an activity start date that could affect month-to-month tracking with my current knowledge.