BookmarkSubscribeRSS Feed
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.
2 REPLIES 2
afterword

Community Trekker

Joined:

Jun 23, 2011

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.
Highlighted
XanGregg

Staff

Joined:

Jun 23, 2011

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: