I'm not sure if this is possible but figured I should ask.
My boss is wanting a static count of Enrollement_Status = 'Open' across each month.
So for example Count only when it's the last day of the current month for all Enrollement_Status = 'Open' and then store as a static result in a chart. Do the same every month(last day) but the following month's counts do not change.