I believe it's a good idea to think about the possibility to generate fields (in views) that create aggregate data.
For example, if I have some fields in DB table where you store your daily expenses, I would like to create,in a view with the grid, a field that bring me back the total expenses in the week or month.

it is already possible to do such a thing? if not, there are plans to implement it?

Not in our plans at all.

It is very easy to write this in your component and there are several different ways to proceed it.
It depends if you want to sum
- filtered datas only (based on dates for example)
- only in current pagination
- all items.



We can immagine lot of functionnalities like that one, but I am affraid it is too much specific for Cook.
Let's see in the future if others users ask for this.


(In your case, a range of dates are also not handled yet in the filters)

TODO :
Create a predefined optimized query in your model that returns such data.
If you do it well in the model, it will be possible to get it from anywhere in your component.

Thanks for the speedy and accurate response. I will try to modify the model as you suggested.
Thanks a lot!!

How did you get on with gathering your aggregate data in your model?

TIP: If you're doing this you'll need to use SELECT DISTINCT your_field AS your_aliased_total in your joined data otherwise you'll get issues
Gez