nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

817055_en-US

liliconcom

Is there a bug when split based on a column when some group doesn't contain all split element

Dosage column doesn't have >=3 row under Surf Rose Fresh, when I split based on Dosage column, Surf Rose Fresh is wrongly changed to Tide - Powder With Downy Garden Bloom, and put value 100%(should be under Tide - Powder With Downy Garden Bloom) to >=3 cell.

please refer to attachments.

Re: Is there a bug when split based on a column when some group doesn't contain all split element

Xiaolin,

when grouping by Detergent Brand and Detergent Variant the split should be done correctly. In the JMP Help you will see that when having unequal groups the Group variable is recommended to be used.

Form JMP Help

"Specifies a Group variable when you want your data to be split within each group of the selected variable. Each group results in a row in the output table. You must also specify the required variables, Split By, and Split Columns.

Note: If the variable that you want to group by contains unequal groups or is in a random order, specifying it as the Group variable ensures that your data is restructured properly, and any missing values are assigned in the appropriate places."

Best Regards

Silvio

Re: Is there a bug when split based on a column when some group doesn't contain all split element

Silvio,
Thank you very much. I realized that "Group" might be the reason when I split other data table using group function. Well get this tip!