data-math="ignore" is not ignored (Math Widget)

[JamoCA]

I'm generating a table with numeric values, but some records don't have any data. In this case, I'm not outputting any value and the TD element is empty. I noticed that the math widget was converting these empty values to "0" when averaging, so I added data-math="ignore" to these empty TD elements. The cells are still being converted to "0" and included in the average.

For example, the mean of non-ignored fields should be "100". The value "60" is returned, so this must mean that it's evaluating ignored cells as "0" instead of ignoring them. (By comparison, if I create 5 cells in Excel and only 3 are populated w/100, the average is "100".)

<script>
$(function(){
	$('#mathTable').tablesorter({
		widgets: ['math'],
		widgetOptions : {
			math_debug: true
		}
	});
});
</script>

<table id="mathTable" class="tablesorter-blue">
<thead>
	<tr><th>ID</th><th>Value</th></tr>
</thead>
<tfoot>
<tr>
	<th data-math="col-count"></th>
	<th data-math="col-mean"></th>
</tr>
</tfoot>
<tbody>
	<tr><td>1</td><td>100</td></tr>
	<tr><td>2</td><td>100</td></tr>
	<tr><td>3</td><td>100</td></tr>
	<tr><td>4</td><td data-math="ignore"></td></tr>
	<tr><td>5</td><td data-math="ignore"></td></tr>
</tbody>
</table>

The console outputs:

col-count  (5) [0, 1, 2, 3, 4] = 5
widget-math.min.js:2 col-mean  (5) [100, 100, 100, 0, 0] = 60

Am I missing something?

[Mottie]

Hi @JamoCA!

The data-math="ignore" is meant to be added to the tr (demo):

<tr data-math="ignore"><td>4</td><td></td></tr>

Is there a case where we'd need data only from specific cells in a row? If so, I'll need to modify the widget.

[Sneezeplease]

Hello,

I would very much like to see this added to the widget. I am running into a similar problem.

[Mottie]

Hi @Sneezeplease!

Do you mean you want the ability to add data-math="ignore" to a cell as well as a row? Or something else?

[JamoCA]

Yes... ignore a table "TD" cell . Please, please please.

That's what I initially thought it was doing. I didn't realize, even after reviewing the documentation/sample, that it was a row-only attribute.

The reason for it is because I'm averaging some data for a client, but some records don't have any response data. In those cases, I leave the table cell is empty (ie, null) but tablesorter auto-translates the missing value to "0" and then the averages are incorrect & unusable. (By contrast, MS Excel automatically ignores empty cells when performing math functions.)

[Mottie]

Sorry, I missed adding this enhancement in today's release. I'll make sure to include it in the next one.

[JamoCA]

I just noticed that a new release became available 2 hours ago. I didn't see any change in behavior. In my sample (above), I'm expecting that the result of 3 populated cells w/100 be displayed as "100" instead of "60" as the two empty (non-zero) cells are ignored, . The v2.30.7 release is still including the ignored cells. (I tested count, mean or sum functions.)

Was the enhancement included in the v2.30.7 release? If not, do you have a separate script I could try? Thanks.

[Mottie]

Sorry, I keep neglecting old issues... I'll really try to include this in the next update.

[JamoCA]

I checked v2.31.0 (8/27/2018) and data-math="ignore" is still including the non-existent values in the calculations. Was the enhancement added to v2.31?

[Mottie]

Sorry, no this enhancement wasn't included. I've been busy and neglecting work on this repo 😿. It is on my to-do list for the next update though!

[JamoCA]

I saw that there's been a 2.31.1 update to the math widget on 11/20/2018. It doesn't look like this enhancement has been added yet. :(

[Mottie]

Sorry :(

New baby, new job... I'm a bit overwhelmed.