Showing statistics in Div, not in grid Footer

Suite and Optimus Suite 5
#1

Hi,

DHTMLX grid shows statistics(like sum, avg) in grid footer. Is it possible to show in some other division. The reason for this question, we want to show statistics like summary in some other places. Kindly assist us.

#2

There is no such method to get that statistic.
You will have to calculate that statistic manually.
You may use the forEachRow method to iterate through the rows of your grid so you can manipulate with its data:
docs.dhtmlx.com/api__dhtmlxgrid_foreachrow.html

#3

Thanks for your reply

#4

How to get filtered value in filter event?

For example i have grid with 10 records, After filter i will have 4 records, I want to get 4 records (filtered value) alone.

#5

Using the following code you may get all the column indexes, where the filter is applied, and the id’s of all the filtered rows:
myGrid.attachEvent(“onFilterEnd”,function(elem){
for(var i=0; i<elem.length; i++){
if(myGrid.getFilterElement(elem[i][1]).value)
console.log("filter column: "+elem[i][1])
}
myGrid.forEachRowA(function(id){
console.log("filtered row= "+id)
})
})
Here you can find an example:
snippet.dhtmlx.com/d1bd1b911

#6

Thanks, It is working fine