Not sure if there’s an easy way, but here are two hard ways:

1. Create separate models for each of your date conditions, and then use templates to show the values and panel sets to format them like a table.
2. Use one model, and put your events aggregation on a table 12 times (or however many columns you want). Then run a different custom field editor on each column to limit the values to the date range you want for that column with javascript.


I’m really hoping there’s a better way…

wow… thats painful. I am thinking this is going to be a ton of Javascript

The other painful way is to create separate models for each date condition and then use custom renderers on a primary model that grep the additional models and post the correct values for the correct person.  

But hint hint…  I think there will be a feature in Banzai that will let you do some of this declaratively.  Check back in a few weeks when its out and open and I can describe. 

That sounds like you guys are heading in the right direction. I am underway with the process you describe above, seems like its going to work. I am going to have to set a condition on page load to the models for date and then the field render-er will go loop the models and find the matching User aggregate to get the count.

Is there a way to Grep a Model in the API to get the single row, or should I just loop the models and check field values until i get a hit?