I have a huge data sheet that I'm trying to simplify for easier understanding. I'm trying to group all the same dates together into one. I included two pictures of the successful before and after when I go to "Tables" -> "Tabulate" -> moves the INSPDATE to "drop zone for rows" and click on "Add Group Columns."
That was the successful one. However, when I tried to do the same thing to another data sheet, it would not group together all the dates. It would still look like the before pictures. Any clues of how to fix it? Any ideas? Your help will be much appreciated.
Here's two attachment of the JMP file if you want to experiment it yourself. The one that said "success" is the one that work. The 2nd one that say "failure" is the one that doesn't work. Maybe there's a different in format between this two. Hope you can solve it.
If you expand the format of the Date column to include the time (m/d/y h:m:s), you'll see that the time in the success dataset is all at 12:00. But the date column in the failure dataset has many different values for time.