Count When: Static Count

[Anonymous]

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.

Can this be done? If so, where would one start?

[#2]

Hi John,

I think what you want is create a chart with

- Date as Dimension

- Anexpression :

=count(DISTINCT if([Start Date Month] <= Date  and [End Date Month] >= Date and Status = 'Open' , Member)) 

is it what you want ?