How to get average value.

[Mpod SchuzatckyParticipant]

Hi Mates,

I’ve edited some codeigniter code, there is view that show data in grid using jqgrid. like picture below.

And here the code to show sum value :

{
text: ‘Akurasi Stok WIP Keramik’,
align: ‘center’,
datafield: ‘akurasi’,
filterable: false,
cellsformat: ‘n’,
cellsalign: ‘right’,
width: 120,
aggregates: [
{
‘total’: function (aggregatedValue, currentValue, column, record) {
return aggregatedValue + currentValue;
}
},
],
aggregatesrenderer: function (aggregates, column, element, summaryData) {
var renderstring = “<div style=’padding:5px’>”;
var total = aggregates.total;
renderstring += total;
renderstring += “</div>”;
return renderstring;
}
},

The questions is, how to get average value? because im not familiar with jqgrid.

Thanks, Fadli.

[MariyaParticipant]

Hi mpod555,

Thank you for your interest in jqxGrid. Take a look at the provided example at: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/aggregatesrenderer.htm?arctic If you have any further questions do not hesitate to contact us.

Best Wishes,
Mariya

jQWidgets Team
http://www.jqwidgets.com

[Mpod SchuzatckyParticipant]

Thanx for fast respons.
I’ve seen the demo before, but still confused how to combine in this code below.

{
text: ‘Akurasi Stok WIP Keramik’,
align: ‘center’,
datafield: ‘akurasi’,
filterable: false,
cellsformat: ‘n’,
cellsalign: ‘right’,
width: 120,
aggregates: [
{
‘total’: function (aggregatedValue, currentValue, column, record) {
return aggregatedValue + currentValue;
}
},
],
aggregatesrenderer: function (aggregates, column, element, summaryData) {
var renderstring = “<div style=’padding:5px’>”;
var total = aggregates.total;
renderstring += total;
renderstring += “</div>”;
return renderstring;
}
},

can u help how to add code (what i must add) to get average value replace sum value.

[MariyaParticipant]

Hi mpod555,

Can you please provide us with an example using jsFiddle?

Best Wishes,
Mariya

jQWidgets Team
http://www.jqwidgets.com

[Mpod SchuzatckyParticipant]

[SOLVED]
Finally, i get what i need, thnx Mariya for your inspired reply…. nice to meet u btw…

I’m modified some code here :

{
text: ‘Akurasi Stok WIP Keramik’,
align: ‘center’,
datafield: ‘akurasi’,
filterable: false,
cellsalign: ‘right’,
width: 120,
aggregates: [‘avg’],
aggregatesrenderer: function (aggregates, column, element, summaryData) {
var renderstring = “<div style=’padding:5px’>Rerata: “;
var total = aggregates.avg;
renderstring += total.toFixed(2);;
renderstring += ” %</div>”;
return renderstring;
}
},

Note : How to closed this thread as closed / solved?

[Author]

Posts