Search the Community
Showing results for tags 'totals aggregation groups'.
I have a table which includes a timestamp and a type field (among others) I've created triggers and a view that combines this table into itself and displays a clock-in time, clock-out time, and a total time difference between them in HH:MM format. The formula in the calculated field is below: CONVERT(varchar(5), DATEADD(minute, DATEDIFF(minute, [@field:Patrol_Activity_Database_Date], [@field:Patrol_Activity_Database_1_Date]), 0), 114) My issue is that I need to have a total/aggregate for this field, but it gives an invalid error if I just do sum, and I've been unable to figure out
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 T