User Manual
How can we help?
Full Site Search

Total and Summary

Viewing Total & Summary

While using Ragic in some cases you will need to quickly view a summary of your data according to the values in your database. For single fields, Ragic can display a quick count, averages, the number empty values, and other various data that might change according to the field type. You can use filters to refine the values being displayed.

To view this short summary, click on the arrow next to your field header in the Listing Page, and click on Total & Summary.

List of Summary Types Available According to Field Types

Clicking on Total & Summary will display a list of values according to your field type.

Numerical Fields

This includes numeric fields, and numeric fields that have a format applied, such as money fields.

Summary NameDescription
TotalCalculates the total of the values in this field for filtered records
AverageCalculates the average of the values in this field for filtered records
MinDisplays the minimum value in this field for filtered records
MaxDisplays the maximum value in this field for filtered records
EmptyDisplays the number of empty values this field has for filtered records
CountDisplays the number of records for the applied filter

Selection Fields

Includes selection fields and multiple selection fields.

Summary NameDescription
CountDisplays the number of records for the applied filter
EmptyDisplays the number of empty values this field has for filtered records
[Option Name]Displays the option name, and the number of values this field has under this option for filtered records

Date Fields

Summary NameDescription
EarliestDisplays the earliest date value within this field for filtered records
LatestDisplays the latest date value within this field for filtered records
EmptyDisplays the number of empty values this field has for filtered records
CountDisplays the number of records for the applied filter

Advanced Calculations

The Total & Summary feature is meant to be used for a summary at a glance. If you need to view and save a summary that is more advanced, you can use the report types available in Ragic. (Only the SYSAdmin can save generated reports.)

Top of Page Table of Contents

Start Ragic for free

Sign up with Google