/
Using Grid Stats

Using Grid Stats

 

Grid Stats is a OneVizion Platform feature accessible from the Command Bar on Trackor Browser pages. This feature provides easy access to statistics and basic graphs for the grid based on a selected field (column).

The Grid Stats example below shows statistics based on a drop-down field for “current condition.”

image-20240724-144400.png
Grid Stats Example

 

Accessing Grid Stats

Typically users access Grid Stats on the ellipsis menu from the Command Bar. If, however, you find that you frequently use Grid Stats on a particular page, you may choose to pin this button to the Command Bar for easier access. See Pinning Items to the Command Bar for more information. Before accessing Grid Stats, filter the grid for the data you want to see statistics for.

 

Grid Stats on the Ellipsis Menu

 

Grid Stats are not available when the grid exceeds the number of rows set for the "MaxGridStatsRows" System Parameter. The default for this parameter is 10,000.

 

 

Understanding Grid Stats

Once you access Grid Stats, you have the option to select the field (column) you want to see statistics for in the Columns drop-down field. Grid Stats are then presented under Record Count and Statistics headings.

 

image-20240724-161647.png

 

Record Count

Under Record Count, you see the following highlighted labels:

Total - the total record count

Null - the record count with no values for this field

Values - the record count with values for this field

In most cases, this data is represented in a pie chart.

 

You can click any of the highlighted labels to filter the grid to show the records for that label.

 

Statistics

The statistics displayed by Grid Stats depend on the filter applied to the grid and the field selected in the Columns field. The field type you select determines what Grid Stats displays. The chart below lists what displays for each type of field. You can see the field type listed under Statistics on Grid Stats.

image-20240724-162012.png

 

Field Type

Potential Statistics Display

Field Type

Potential Statistics Display

Text & Memo

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

Total
Average Value
Min Num
Max Num

Date

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 / Selector

List of values with counts and percentages (does not include Null)

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."

Latitude/Longitude

Center on Average
Anything more than 2 standard deviations from the center

E-File

Smallest file size
Largest file size
Date of earliest file
Date of latest file

 

Printing Grid Stats

You can print the Grid Stats display by clicking the printer icon at the bottom of the form.

 

image-20240724-172745.png