I work for a small nonprofit that has just transitioned all of our database systems over to Caspio (and so far so good... really powerful tool).
I have just run into a snag that I was hoping someone could help me out with. We provide services for students with behavioral challenges, so we collect a lot of different data we need to slice and dice to guide our practices. One of the big ones is tracking time out of class. We generally use a number of nested groupings to arrange the data and make it managable for our frontline staff. A standard report might have StudentName>Reason for Timeout>InClass vs. OutOfClass... to see what a students behavior has been like over some period of time.
I have the Search and Report form set up, and the data retreival, search, and grouping all work great. But normally, we would have the time out of class subtotaled for each sub grouping (e.g. How much time did Johnny spend "OutOfClass" for "Disrupting" this week. I found the aggregation function for reports, but I can only get it to apply to the first grouping (e.g. How much total time did Johny spend in TimeOut). Is there a way to apply aggregation to sub-groupings, and if not is that something that could be submitted as a feature request?
I imagine it's a more universal need (grouping and sub totaling sales, or projection for different associates or regions, etc), so if it is already in the system and I'm just missing something please let me know.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
AIPjames
I work for a small nonprofit that has just transitioned all of our database systems over to Caspio (and so far so good... really powerful tool).
I have just run into a snag that I was hoping someone could help me out with. We provide services for students with behavioral challenges, so we collect a lot of different data we need to slice and dice to guide our practices. One of the big ones is tracking time out of class. We generally use a number of nested groupings to arrange the data and make it managable for our frontline staff. A standard report might have StudentName>Reason for Timeout>InClass vs. OutOfClass... to see what a students behavior has been like over some period of time.
I have the Search and Report form set up, and the data retreival, search, and grouping all work great. But normally, we would have the time out of class subtotaled for each sub grouping (e.g. How much time did Johnny spend "OutOfClass" for "Disrupting" this week. I found the aggregation function for reports, but I can only get it to apply to the first grouping (e.g. How much total time did Johny spend in TimeOut). Is there a way to apply aggregation to sub-groupings, and if not is that something that could be submitted as a feature request?
I imagine it's a more universal need (grouping and sub totaling sales, or projection for different associates or regions, etc), so if it is already in the system and I'm just missing something please let me know.
Thanks so much in advance for your help.
Best,
James
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.