Creating a total count for read only table in display box

Hey All, 

I would like to create a display box that shows the count of how many total applications we received. For some reason I am not getting the total count of the number of application. Any advice?

The code for the table: 

a!gridField(
data: queryrecord(
recordType: cons!OCS_Services_Portal_Application_Record,
query: a!query(
aggregation: a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "Division",
isGrouping: true
),
a!queryAggregationColumn(
field: "AppId",
aggregationFunction: "COUNT"
)
}
),
pagingInfo: fv!pagingInfo
)
),
columns: {
a!gridColumn(
label: "Division",
sortField: "Division",
value: fv!row.Division
),
a!gridColumn(
label: "Number of Applications",
sortField: "AppId",
value: fv!row.AppId
)
},
pageSize: 20,
initialSorts: {},
selectable: false,
spacing: "DENSE",
height: "SHORT",
shadealternaterows: false
)

The code for the display box:

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data