• Caspio.com
  • Forum
  • Blog
  • Apps
  • Support
  • Free Trial

Caspio Online Help

Videos » Getting Started Videos » Advanced Reporting » Advanced Reporting (2 of 3) Grouping and Aggregations

Advanced Reporting (2 of 3) Grouping and Aggregations

 

<< Part 1 Part 3 >>

Loading

Help Topics

  • Welcome to Caspio Online Help
  • ▶Introduction to Caspio Bridge
    • What is the advantage of using a Web Database?
    • Why Use DataPages?
    • Caspio Bridge Environment
    • ▶Caspio Bridge System Requirements
      • Known Issues
  • ▼Videos
    • ▼Getting Started Videos
      • ▶Create a Web Form
        • Create a Web Form (1 of 3) Create a Table
        • Create a Web Form (2 of 3) Create a DataPage
        • Create a Web Form (3 of 3) Deploy a DataPage
      • ▶Create a Searchable Database
        • Create a Searchable Database (1 of 3) Import a Table
        • Create a Searchable Database (2 of 3) Creating a Report
        • Create a Searchable Database (3 of 3) Cascading Dropdowns
      • ▶Password Protection
        • Password Protection (1 of 3) Lookup and Authentication Tables
        • Password Protection (2 of 3) Authentication and Logout Links
        • Password Protection (3 of 3) Authenticated Data and Password Recovery
      • ▶Creating Your Caspio App
        • Creating Your Caspio App (1 of 3) Planning Your App
        • Creating Your Caspio App (2 of 3) Creating Your DataPages
        • Creating Your Caspio App (3 of 3) Website Deployment
      • ▶Record Level Security
        • Record Level Security (1 of 3) Stamping New Records
        • Record Level Security (2 of 3) Create a Filtered Report
        • Record Level Security (3 of 3) Filtered Dropdowns
      • ▼Advanced Reporting
        • Advanced Reporting (1 of 3) View Construction
        • Advanced Reporting (2 of 3) Grouping and Aggregations
        • Advanced Reporting (3 of 3) Calculated Fields
    • ▶Full Implementation Videos
      • Social Networking Site
      • Event Calendar System
    • ▶Recorded Training Sessions
      • Basic DataPages and Deployment (1 of 2)
      • Password Protection & Advanced Features (2 of 2)
  • ▶Tables
    • How do I Create a New Table?
    • About Data Types
    • Importing Data
    • Managing Data
    • Modifying Tables
    • Field Re-ordering in Table Design
    • Table Relationships
    • Lookup Tables
    • Exporting Data
    • ▶Scheduled Import/Export Tasks (DataHub)
      • Scheduled Import Tasks (DataHub)
      • Scheduled Export Tasks (DataHub)
      • Define an External Site
  • ▶DataPages
    • ▶Creating DataPages
      • ▶Creating a Submission Form DataPage
        • Add a Dynamic Redirect After Form Submission
        • Add Separate Input Fields for Date/Time Parts
      • ▶Creating a Report DataPage
        • Update Records Using a Details Page
        • Search and Filter Comparison Types
        • How to make Search Results Downloadable for Users
        • Limiting Records per Page and Total Records Returned
        • How to Add Today to “After Now” or “Next X Days” Criteria
      • Creating a Chart DataPage
      • ▶Creating a Combined Chart and Report DataPage
        • Combined Chart and Report – Example
      • ▶Creating a Calendar DataPage
        • Calendar DataPage – Monthly Example
        • Calendar DataPage – Weekly Example
      • Creating an HTML Page DataPage
      • Creating an Update Form for User Profile Information
      • Creating a Password Recovery DataPage
      • Creating a Mobile Form DataPage
      • ▼Advanced Reporting
        • ▶Calculated Fields
          • Caspio Bridge Function Reference
        • Data Grouping
        • Totals & Aggregation
      • Previewing DataPages
      • Inline Options for DataPages
      • Relative Paths in Destination Page Redirection
    • ▶Form Elements
      • HTML Blocks
      • Header and Footer
      • How to Display a Field Data as Hyperlink
      • Repeat Input Fields to Prevent Misspellings
      • ▶Dropdowns and Listboxes
        • ▶Dynamically Add Options to Dropdowns and Listboxes
          • Add an Option to a Public Facing Dropdown
        • Adding an “Any” Option to a Dropdown
        • Multi-select List Boxes in Search Forms
        • Cascading Dropdowns and Listboxes
        • Default Choices in Dropdowns and Listboxes
      • Remaining Character Count in Text Areas
      • AutoValue
      • Radio Buttons: Selecting All Options
      • Stamp the Time and/or URL on a New Submission or Update
      • In Action: Creating an “I Agree” Checkbox
    • Creating Conditional Forms with Rules
    • Editing DataPages
    • ▶Managing DataPages
      • Moving DataPages
      • Copying DataPages
      • Exporting a DataPage
  • ▶Deployment
    • ▶Deploying DataPages
      • Embed DataPages in the Webpage Header
    • ▶SEO Deployment
      • SEO Deployment Guidelines
      • Sitemap Generator for Caspio SEO Deployments
    • Block Access to DataPages by IP Address
    • ▶Iframe Deployment
      • Create a List Report Showing Associated Records from a Second Table
      • Make Any Iframe Resizable
      • Remove the Iframe Border and Change the Size
      • Create an Embeddable Tabbed Interface
    • Deploy Caspio DataPages in WordPress
  • ▶Automatic Emails
    • Acknowledgement Emails
    • ▶Notification Emails
      • Troubleshooting Notification Emails
    • File Attachments in Automatic Emails
  • ▶Authentication and Security
    • ▶Web User Authentication
      • How to Create a Logout Link
      • How to Hide Multiple Login Screens
      • ▶Create a Standalone Login Screen
        • User Specific Redirects from Stand Alone Login Screens
      • Creating User Permissions in your App
    • ▶Record Level Security
      • Stamp a Record with User Profile Data
      • Restrict Access to Records by User or Department, etc.
      • Lookup Table Filtered by RLS
      • In Action: Creating a Workflow Using RLS and Filtered Drop Downs
    • Adding Encryption to DataPages
    • Blocking Spam with CAPTCHA
    • DataPage Folders
  • ▶Styles and Formatting
    • About Styles
    • Creating a Style
    • ▶Layout Options
      • Change the Default Alignment of Field Labels
      • Change the Button Cell Alignment
    • ▶Border Options
      • Add Rounded Borders to Fields
    • ▶Font Options
      • Design Using Google Web Fonts
      • Creating Glossy Heading Text
    • ▶Advanced Style Options
      • Adding a Gradient Background to Fields
      • Add a Background Gradient
      • Replace Record Links with Images
      • Replace Standard Buttons with Images
      • Change the Color of Error Field Labels
    • Exporting and Importing Styles
    • Set the Width of a DataPage
    • ▶Web Form Columns and Configurations Options
      • Adding Multiple Column Formatting to DataPage Sections
      • Adding Multiple Elements on a Single Line
    • Styling for Advanced Reporting
  • ▶Files and Images
    • Uploading Files and Images
    • Adding a Lightbox to View Images
    • Referencing an Image Stored in Caspio Bridge
    • Creating Thumbnails with the Image Resizer
  • ▶Localizations
    • ▶Creating a Localization
      • Arabic, Hebrew and Other Right-to-Left Languages
    • Format Types
    • Formatting and Rendering
    • International Dates in Calendar Fields
    • Exporting and Importing Localizations
    • Customize Localizations to Improve Usability
  • ▶Views
    • Create a View to Filter a Table
    • Creating a View to Join Tables
    • Modifying Views
    • Importing Views
    • Exporting Views
  • ▶Parameters
    • Enable Parameters
    • Displaying Parameters
    • Passing Parameters through Caspio Bridge
    • Passing Parameters Using a Query String
    • Receiving Parameters
    • Resetting Parameters
    • Parameters in Dropdowns, Listboxes and Radio Buttons
    • Creating Dynamic Labels
    • ▶Parameters In Action
      • In Action: Add a Search Interface to a Results Page
      • In Action: Results and Details in Two Separate Web Pages
      • In Action: Display a Personalized Message to Your Users
      • In Action: Multi-Page Forms
      • In Action: One-To-Many Relational DataPages
      • In Action: Search Page and Results Page in Two Different Webpages
      • In Action: Link a Results Page to a Results Page
  • ▶Account Management
    • Account Alerts
    • ▶Internal Users and Groups
      • Table Security
      • DataPage Privilege Control
      • Privileges of Internal Users
      • Managing Groups
      • Managing Privileges
    • Backing Up Your Applications
  • ▶Common Customizations
    • ▶DataPage Interface Additions
      • How to Add a Reset Button in the Web Form to Clear Entries
      • Search Again Link on the Results Page
      • Add a Mouse Over Help Icon
      • Create-an-Add-to-Outlook-link
      • Creating Date Specific New Record Links in Calendar DataPages
      • Add Auto-Clearing Default Text to Form Input Fields
    • Hide Fields in DataPages
    • Create an Approval Process for New Records
    • Generate Link Menus and Pop-up Windows
    • Dynamically Change the Background of a Results Page Record
    • Limit the Number of Maximum Submissions
    • Vote Up – Vote Down Individual Records
    • Create an Auto-Scrolling Record Viewer
    • Create a Floating Feedback Tab
    • Add a Time Limit to Submission Forms
  • ▶Extensions
    • ▶Social Media
      • Add a Tweet This Link
      • Add a Facebook Like Button
      • ▶Create Facebook Apps and Page Tabs with Caspio DataPages
        • Display a User's Facebook Profile Photo
      • Create an Add This Button
    • ▶iPhone, iPad and Smartphone Solutions
      • In Action: Using the iPhone Kit
      • How to Add QR Codes to Your App
    • ▶Caspio Bridge Plugin for MS Office
      • Install Plugin for 32-bit Microsoft Office 2007-2010
      • Install Beta Plugin for 64-bit Microsoft Office 2010
      • Plugin for Microsoft Office 2003 (Not Supported)
    • ▶Maps
      • ▶Map Mashup Instructions
        • ▶Map Mashup Version 7 – Beta
          • Beta Release 2
        • Instructions for Older Version of Map Mashup
      • How to Use Geocodes Instead of Address in Map Mashup
      • How to Change Text Color or Style in the Map Bubble
      • How to Set Up a Distance Search
      • Hide the Map When No Results Are Found
    • Adding a PrintWhatYouLike Link
    • Convert Existing HTML Forms to Submit Data to Caspio Bridge
  • ▶Release Notes
    • Caspio Bridge 7.3
    • Caspio Bridge 7.2
    • Caspio Bridge 7.1.5
    • ▶Caspio Bridge 7.1
      • 7.1.1 Patch
    • ▶Caspio Bridge 7.0
      • 7.0.1 Patch
      • 7.0.2 Patch
    • Caspio Bridge 6.9.5
    • Caspio Bridge 6.9
    • What is New in Caspio Bridge 6.9
    • ▶Caspio Bridge 6.8
      • 6.8 Interface Changes
    • Caspio Bridge 6.7
    • Caspio Bridge 6.6
    • Caspio Bridge 6.5
    • ▶Caspio Bridge 6.0
      • Faster Wizard Navigation
  • ▶Tech Tips
    • Tech Tip: Generating Geolocation Coordinates from Web Form Submissions
    • Tech Tip: Embed Documents in DataPages
    • Tech Tip: Leverage the Power of Social Media in Your Apps
    • Tech Tip: Integrate Google Analytics into Submission Form DataPages
    • Tech Tip: Optimize Your Web Forms for Maximum Usability
    • Tech Tip: Creating a Floating Navigation Menu
    • Tech Tip: Custom Filter Elements
    • Tech Tip: Dynamically Add Options to Dropdowns and Listboxes
    • Tech Tip: How to Validate a User Email Address
    • Tech Tip: Creating Collapsible Sections
    • Tech Tip: Adding a Zoom Window to Images
    • Tech Tip: 5 Ways to Customize the Look of Your DataPages
    • Tech Tip: 5 Techniques to Create Web 2.0 Style Design
  • ▶Instant Apps
    • Classified Ads
    • Business Directory
    • Vacation Requests
    • Resource Scheduling
    • Subscription Membership
    • Feedback Management
    • Knowledge Base
    • Store Locator
  • ▶FAQ
    • ▶DataHub
      • What IP address range Caspio is using for DataHub?
      • Does DataHub utilize data transfer?
      • Does DataHub utilize emails?
    • ▶Import and Export
      • Why my data import is slow and how to speed it up?
      • Will the Appkey change if I export a DataPage and import it into a different account?
      • Will the Appkey change if I export a DataPage, delete it and re-import it back into same account?
    • ▶Geocoding and Distance Search
      • Can I use Distance Search with UK Postal codes or other countries?
    • ▶Authentication
      • Why user cannot login to app or DataPage?
      • Why DataPage Logout redirects to Caspio.com?
      • How to separate login form from an authenticated DataPage?
    • ▶Time and Date
      • How to eliminate Time from a Date dropdown?
      • Why Date Fields from Excel Import Incorrectly?
      • How to subtract two dates to calculate date difference, like the age of a person?
    • ▶Map-Mashup
      • How to hide the map if no records found on the result page?
      • How to change text color or style of the map bubble?
      • How to display a dynamic image inside a map bubble?
      • How to use geocodes instead of address in map mash-up?
      • How to set a default map for when there are no records?
    • ▶Deployment
      • Troubleshooting Search Engine Optimized (SEO) Deployment
      • What is my Caspio site number?
      • Troubleshooting deployment in WordPress
      • How to embed Caspio on Ning?
      • How to Resize an iframe
    • ▶Web Forms
      • How to remove blanks from a dropdown or listbox?
      • How to add a reset button to my form to clear entries?
      • Why do I get Error: "Duplicate values are not allowed …"?
      • How to Limit Votes to One per User?
    • ▶Reports DataPages
      • Why do I get "error in formula" message in a Report DataPage?
      • How to auto refresh a page?
      • How to determine the number of years between two dates?
      • How to calculate date difference such as days between when a record was submitted and now?
      • How to do Keyword Search across multiple fields?
      • How to do conditional or IF, THEN, ELSE in calculated fields?
      • Why the sorting of my numbers is wrong?
      • How to display a field data as hyperlink?
      • How to make the search results downloadable for my users?
      • How to add "Today" to "After Now" or "Next X Days" criteria?
      • How to put a “Search Again” link on my DataPage?
      • Why strange characters on my DataPage?
      • How do I edit data through my Details page?
      • How to count the number of times a record has been viewed?
    • ▶JavaScript Issues
      • Why JavaScript is not working with multiple DataPages deployed on one page?
    • ▶Auto Emails
      • Why acknowledgement emails are not received?
      • How Many Addresses are Allowed in Notification Emails?
      • How to set up dynamic or conditional notification emails?
    • ▶API and Microsoft Office Plugin
      • Does Caspio Plugin for Microsoft Office use API calls?
      • Troubleshooting the installation of Caspio plugin for Microsoft Office
      • How can I get Web Services API and Plug-in for Microsoft Office?
    • ▶Styles and Localization
      • How to use an image as form background?
      • How to fix the width of labels and data in List and Gallery reports?
    • ▶Errors and Messages
      • Why do I get "Object moved to here." or "This webpage is not available"?
      • Why do I get Error 50501?
      • Why do I get Error 50510?
      • Why do I get Error 60025?
    • ▶Security, SSL and Encryption
      • How can I find the encryption level of my SSL encrypted DataPage?
      • Can I use Caspio SSL without a website SSL?
      • Why I see no SSL lock icon for my web page?
    • ▶Parameters
      • Why wrong results when parameters are passed to search form?
      • How to pass multiple values in one parameter?
      • How to clear parameter when value is blank?

Recently Updated Pages

  • In Action: One-To-Many Relational DataPages on 24th May'13
  • Welcome to Caspio Online Help on 18th March'13
  • Creating a Report DataPage on 16th March'13
  • Creating a Submission Form DataPage on 16th March'13
  • Tech Tip: Integrate Google Analytics into Submission Form DataPages on 11th March'13
  • SEO Deployment Guidelines on 7th March'13
  • Instant Apps on 6th March'13
  • Basic DataPages and Deployment (1 of 2) on 4th March'13
  • Password Protection & Advanced Features (2 of 2) on 4th March'13
  • Recorded Training Sessions on 4th March'13
© 2013 Caspio, Inc. All rights reserved. Terms of Use | Privacy Statement Suffusion theme by Sayontan Sinha