How to count rows when a cell is not - empty in a column BY GROUP

thegamechangerpro

Essentially, In my group rowsI have the rows.count to show total records in each group. I would like to add the count of "complete" rows next to it.

So if Col[1] !== '' count that row for that group.

Everything i have tried breaks my solution.

kthorngren

Sounds like you are using the RowGroup extension. In the rowGroup.startRender or rowGroup.endRender functions you can use the rows parameter to loop through all the rows, on the page, for the group. Use rows().every(), for example:

        rows.every( function ( rowIdx, tableLoop, rowLoop ) {
          var data = this.data();
          // ... do something with data(), or this.node(), etc
        } );

If this doesn't help or you aren't using RowGroup then please post a link to your page or a test case replicating the issue so we can help debug.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin