BookmarkSubscribe
Choose Language Hide Translation Bar

Summarize by minute

The table that I imported has the column in character format for the date/time (MM/DD/YYYY H:MM:SS.XXX) entries. I will like to summurize by minutes instead of seconds. I also try and failed to create a new column in order convert to numeric with short day format.
0 Kudos
2 REPLIES 2
Highlighted
afterword
Community Trekker

Re: Summarize by minute

Are you importing the data from an SQL compatible database? If so, you can do the summary on the server before importing into JMP.
0 Kudos
XanGregg
Staff

Re: Summarize by minute

I think you have the right idea with a formula column, but I don't think JMP's date parsing supports fractional seconds. An easy way to remove that is the Words() function. For example:

0 Kudos