Caspio must support "group by" and Calculations in views, not only in datapages.
This option will allow us to create views that groups the records of a big table based on some distinct criteria. Also it is necessary to make simple calculations such us sum, or count in our tables without the need of datapages.
-
Bradley Edey commented
The people want group by in views! 3 votes!
-
David Poytinger commented
This is an absolute MUST HAVE feature. Please make it happen. MS ACCESS has it...Caspio should too.
-
Floris commented
Group By and consequently sums and counts in Views, I deem as a crucial part of a database.
Often you don't want to show the detail in reports (as the detail information should be restricted to a few users), but on overview of data can be shown yo all. -
Floris commented
Grouping is imported for views to get a unique data set, for example to be used as a dropdown lookup source in a report datapage, so only those items can be searched which will retrieve results as they exist in the underlying table.
-
Bryan commented
Combine this and "Ability to have calculated fields on a view." and we have one of the top requests!
-
Sean Morrison commented
Either this or just give us custom SQL in views, it would make such a huge difference
-
Sean Morrison commented
This would make a huge difference for me too, really need this kind of functionality for views
-
Anonymous commented
agree strongly, otherwise we are not able to fully utilize this powerful data base for more complex query features.
-
Matt commented
Yes, I would really like to be able to make a view from a combination of views and tables as well. This would as a lot of capability to the program.
-
Karel Kuzel commented
Yes, I agree with this feature. Furthemore, I should vote for the possibility to create views not only from tables but from views as well.
-
Alexander Kazakov commented
Absolutely!
-
Simon Verdon commented
I certainly agree with having the option to use calculations in views. I have some datapages with great working calculations, but I can't automate the extractions with calculations in which is a real shame.