Using Grid Stats

Grid Stats allow you to select any column in the Grid and see a quick breakdown of statistics including record count, total, average, min, and max values. Grid Statistics are located in the Grid Menu (ellipsis).

Click here for a Video Tutorial on Grid Stats

Grid Stats Applet

The limit of the displayed messages of the drop-down list/selector for the grid stat is 25. Users may expand the combined values when clicking on the item "Other"

Field Type Selected	Statistics Displayed
Text & Memo	Field Type Max Length (max characters allowed) Average Length (average number of characters for fields that are not null) Shortest (field with shortest character count) Longest (field with longest character count)
Number	Field Type Earliest Date Latest Date Dates per month for the past 3 months Dates per week for the past 10 weeks Dates per day for the past 10 days
Drop-Down	List of entries with counts Entries with NULL values are not included
PS Trackor Selector	Field Type List of entries with counts
Latitude	Center on Average Anything more than 2 standard deviations from the center
Longitude	Center on Average Anything more than 2 standard deviations from the center
Electronic File	Smallest file size Largest file size Date of earliest file Date of latest file

Users are able to print from the Grid Stats page by clicking on the printer icon.

By selecting the Column users will be able to see the statistics and value usage of each Trackor. An example is shown below.

A Pie chart is shown for fields of type CheckBox, Latitude, Longitude, MultiSelector, DB Selector, Trackor Drop-Down, DateTime, Time, Calculated, Rollup, Wiki.

A Column chart is shown for fields of type Number, Drop-Down, DB Drop-Down, Trackor Selector, Selector, EFile, Text, Memo, Hyperlink, Date.

The number of records by category in the chart is displayed for fields of type Drop-Down, DB Drop-Down, Trackor Selector, Trackor Selector.

For fields with a data type of Number, the chart displays the minimum, average and maximum values.

For fields with a data type of EFile, the minimum and maximum file size is displayed on the chart. Note that these values are converted to kilobytes.

For fields with a data type of Text, Memo, or hyperlink, the chart displays:

the maximum allowable length of the value for the selected field,

the average length of values,

the length of the shortest value,

the length of the longest value.

For fields with a data type of Date, the minimum and maximum dates are displayed on the chart.

The last selected Column in Grid Stats will now be remembered in the browser session.

On this Page

1 Grid Stats Applet