Hi,
We are using IgniteUI version 16.2.20162.1035.
Configuring the grid as follows:
dataSource: '/api/data/' + key,odata: false,responseDataKey: "Data",virtualization: false,
features: [ { name: "Paging", type: "remote", recordCountKey: "recordCountKey", pageSize: 25,showPageSizeDropDown: false }
.....
What's the best way of setting up a summary of average and sum of a column? As we are using remote paging, ideally the summary would be for all records. The code provided at: https://www.igniteui.com/grid/summaries-remote seems to be a bit off and ASP.NET Controller code does not corroborate with the View.
Alternatively we can provide that via the service endpoint, but I cannot find the correct properties to assign those values to. Code provided at: https://www.igniteui.com/help/iggrid-configuring-column-summaries#custom-summaries does not seem to get into too much details on how to hook up to result from the server.
Cheers,
Milen
Hello Milen,
Thank you for contacting Infragistics!
To setup the grid to have a summary by default you would set the summary operands:https://www.igniteui.com/help/api/2017.1/ui.iggridsummaries#options:columnSettings.summaryOperands
{name: "Summaries",showSummariesButton: false, columnSettings: [{ columnKey: "ProductID", allowSummaries: true, summaryOperands: [{rowDisplayLabel: "Avg", "type": "avg", "active": true},{rowDisplayLabel: "Sum", "type": "sum", "active": true}]}]}
Hi Mike,
Thank you for your prompt response. Can you please confirm the setup while using remote paging?
Also it seems like Grouping is not properly working while 'remote' paging is enabled. The number recordCountKey is more than 100, pageSize = 25, and the pages available while grouped by 1 column are always displayed as 2.
For remote summaries the setup would be the same except you would set the type to remote:https://www.igniteui.com/help/api/2017.1/ui.iggridsummaries#options:type
As for the Remote Paging and Remote Grouping there is a known issue where they do not work together:https://www.igniteui.com/help/iggrid-known-issues