DataGrid aggregates

[Costa]

Hi. In Thread 136540 a request was made about the non-working code from Syncfusion help, in particular about the "customAggregate" tag in the DataGrid ASP.NET Core - EJ 2. More than a year has passed, the code from the help is still not working. I have 2 questions: 

1) How and when do you plan to eliminate this discrepancy (if you are planning)?

2) If I use UrlAdaptor and Paging, then aggregate values ​​are displayed only for the records that are on the page. How to make so that the totals are displayed for all records?

 Thanks.

[Thavasianand Sankaranarayanan]

Hi Costa, 

Greetings from Syncfusion support. 

Query 1 : A request was made about the non-working code from Syncfusion help, in particular about the "customAggregate" tag 

We are sorry for the inconvenience caused. We have already logged this as a documentation improvement task, and the corrections are in progress. We have planned to refresh these changes in our upcoming release. Until then we appreciate your patience. We also request you to follow our new documentation link below and replace only highlighted code shown below to render a Grid with custom aggregate,  

 

 

<e-aggregate-column field="ShipCountry" type="Custom" footerTemplate="Brazil Count:${Custom}" customAggregate="@("customAggregateFn")"></e-aggregate-column> 

 

Documentation : https://ej2.syncfusion.com/aspnetcore/documentation/grid/aggregates/#custom-aggregate 

 

Query 2 : If I use UrlAdaptor and Paging, then aggregate values ​​are displayed only for the records that are on the page. How to make so that the totals are displayed for all records? 

We would like to inform you that, by default when you are using a custom aggregate in Grid, only the data in the current view will be taken for calculating the aggregate. This is the default behavior of custom aggregate. When you use the default aggregate, then aggregate  will be calculated based on the entire data in all the pages in Grid. 

From the screenshot we could see that you would like to display “2000” in Total. So we suggest you to use the default aggregate, which calculates the aggregate based on entire data in Grid. Please refer the documentation and code example below, 

 

<e-aggregate-column field="ShipCountry" type="Count" footerTemplate="Count:${Count}"></e-aggregate-column> 

Documentation : https://ej2.syncfusion.com/aspnetcore/documentation/grid/aggregates/#footer-aggregate 

If we have misunderstood your query, we need more details to further proceed on this. So could you please share with us the detailed description of your exact to further proceedon this and provide you a solution as early as possible. 

Regards, 

Thavasianand S. 

[Costa]

"... we suggest you to use the default aggregate, which calculates the aggregate based on entire data in Grid. Please refer the documentation and code example below.

<e-aggregate-column field="ShipCountry" type="Count" footerTemplate="Count:${Count}">e-aggregate-column> "

If this method worked, I would not ask such a question here. But it does not work. To make it easier to understand, I enclose an example. See Attachment.

Attachment: AspNetCore3_EJ2_aa504d24.zip

[Pavithra Subramaniyam]

Hi Costa, 

 

Thanks for the sample. 

 

From your sample we found that you did handle the aggregation in server side. We must need to handle the aggregate action in server side while working with remote data only. Please refer the following code snippet for further assistance,  

 

public IActionResult UrlDatasource([FromBody]DataManagerRequest dm) 

        { 

 

            IEnumerable DataSource = order; 

            DataOperations operation = new DataOperations(); 

 

            if (dm.Search != null && dm.Search.Count > 0) 

            { 

                DataSource = operation.PerformSearching(DataSource, dm.Search);  //Search 

            } 

            if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting 

            { 

                DataSource = operation.PerformSorting(DataSource, dm.Sorted); 

            } 

            if (dm.Where != null && dm.Where.Count > 0) //Filtering 

            { 

                DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator); 

            } 

            List<string> str = new List<string>(); 

            if (dm.Aggregates != null) 

            { 

                for (var i = 0; i < dm.Aggregates.Count; i++) 

                    str.Add(dm.Aggregates[i].Field); 

            } 

            IEnumerable aggregate = operation.PerformSelect(DataSource, str); 

            int count = DataSource.Cast<Orders>().Count(); 

            if (dm.Skip != 0) 

            { 

                DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging 

            } 

            if (dm.Take != 0) 

            { 

                DataSource = operation.PerformTake(DataSource, dm.Take); 

            } 

            return dm.RequiresCounts ? Json(new { result = DataSource, count = count, aggregate = aggregate }) : Json(DataSource); 

        } 

 

Please let me know if you have any concern. 

 

Regards, 

Pavithra S. 

 

[Costa]

Thanks, it works fine. This is the answer that was needed.

[Hariharan J V]

Hi Costa, 

Thanks for your update.  

  

We are happy to hear that the provided solution helped you.   

  

Please contact us if you need any further assistance. As always, we will be happy to assist you.   

  

Regards, 

Hariharan 

[Costa]

Hi. I have one more question. I would like to adjust the aggregate, using UrlAdaptor, so that it display the count of unique values, so to speak, "DistinctCount" or "UniqueCount":

Currently, I do not see such a possibility when using UrlAdaptor, since the built-in aggregate types do not contain "DistinctCount or "UniqueCount", and custom aggregates allows only records displayed on the current page to be processed.

[Hariharan J V]

Hi Costa, 

We have analyzed your requirement. We suggest you to handle the distinct values from the server side. So that, only the distinct values will be returned as aggregates. We suggest you to use the below codes in your application to achieve this requirement. 

 

            List<string> str = new List<string>(); 

            //As aggregate is to be displayed for “CustomerID” column, we have fetched distinct from “CustomerID” field  

            IEnumerable aggdata = OrdersDetails.GetAllRecords().GroupBy(o => o.CustomerID).Select(o => o.FirstOrDefault());     

            if (dm.Aggregates != null) 

            { 

                ... 

           } 

            IEnumerable aggregate = operation.PerformSelect(aggdata, str);   //Provide the distinct data(aggdata) as argument instead of “DataSource” 

We are also attaching the sample for your convenience, please download the sample from the link below, 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/EJ2-dotnet-core-1678589076 

Please get back to us if you need further assistance. 

Regards, 

Hariharan 

[Costa]

Not bad. But how at the same time on the other column to get the full count?

By the way, if the column type is string, you cannot format the aggregate. Of course, in most cases this is not required, but if, for example, it is necessary to format the aggregate in a text column with a separation of groups of digits, then this will not be possible. But, as usual, there is a workaround: to display the aggregate of a numeric column in a text column, formatting them as necessary. So it is not critical.

[Costa]

Okay, I'll answer my own question. I found that the dataSource argument of the method PerformSelect (IEnumerable dataSource, List <string> select) does not have to be the same type as the data type in the grid. It is only important that the names of the columns for displaying the aggregates coincide with the names of the dataSource columns of the grid. At the same time, the option with an grouping by constant (in this case it is "any") and using anonymous type is quite functional:

HomeController.cs:

...

        public IActionResult UrlDatasource([FromBody]DataManagerRequest dm)

        {

    ...

            IEnumerable aggdata = DataSource.Cast<OrdersDetails>()

                .GroupBy(e => "any")

                .Select(e => new

                {

                    CustomerID = e.Select(o => o.CustomerID).Distinct().Count(),

                    ShipCity = e.Count(),