aggregates from seperate columns

[scotkerstenParticipant]

I have 2 columns that I am pulling the total from, doing a bit of math, and then trying to display the ratio of the 2 items.

When I add the following bit of code the entire thing comes to a screeching hault and it takes about 15 minutes to load the grid.

aggregates: [{ '<b>Total</b>':
        function (aggregatedValue, currentValue, column, record) {
	        var sumMiles = $("#jqxgrid").jqxGrid('getcolumnaggregateddata', 'miles', ['sum']);
	        var sumRate = $("#jqxgrid").jqxGrid('getcolumnaggregateddata', 'rate', ['sum']);
	        return sumRate.sum / sumMiles.sum;
        }
}]

[DimitarParticipant]

Hello scotkersten,

Please take a look at the forum topic Grid aggregates accessing other column summary data where a similar scenario is discussed (it is worth reading the entire thread to avoid possible issues).

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[scotkerstenParticipant]

Thanks for the response!!

That thread is actually where I got the snippet of code from. The code actually works fine – it just slows everything down.

When I have the 2 columns showing totals – the grid loads in about 2-3 seconds. When I add on the snippet outlined above, the grid takes close to 10 minutes to load. It does eventually load – and the end result is what I was looking for – it just seems odd that it would take that long…it is almost like it is trying to resolve something that isn’t there.

[DimitarParticipant]

Hi scotkersten,

This issue is discussed in the aforementioned topic (and a workaround is given), starting from this post: http://www.jqwidgets.com/community/topic/grid-aggregates-accessing-other-column-summary-data/#post-50863. As I already suggested, please read both pages of the topic.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts