topic Re: summary function in Discussions

summary function

JMP2021 — Fri, 09 Jun 2023 00:28:53 GMT

I noticed the summary function did not category the row correctly when the table is huge this week.

I have one column (e.g. col A) containing very long characters. I try to see how many unique rows per the content of col A. JMP did generate a summary table without any error messages. To my surprise, the sub-table per the summary table still contains some unique rows. Anyone knows why?

Re: summary function

txnelson — Mon, 15 Feb 2021 17:24:07 GMT

Upper/Lower case mismatches
Double spaces between words for some entries and single spaces for other entries
Preceding or trailing blanks
Non printable characters

Re: summary function

JMP2021 — Fri, 19 Feb 2021 15:54:30 GMT

The discrepancy I observed seems like that the criteria used to define matching row by Table summary function is different from that used by selecting matching rows. is this true? If yes, please elaborate the difference.

Re: summary function

txnelson — Fri, 19 Feb 2021 16:04:53 GMT

If you create a new column, baised ono the grouping column in the Summary that is producing the unique rows, and specify the formula
Hex(your column of concern here)
you will be able to compare the exact values for all of the characters in the cells. What you need to do then, is to compare the unique row data with the non unique row and see what the difference is.