Jump to content

Search the Community

Showing results for tags 'totals aggregation groups'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 2 results

  1. 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
  2. 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
  • Create New...