Choose Language Hide Translation Bar
Highlighted

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
Highlighted
afterword
Level IV

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

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:

Article Labels

    There are no labels assigned to this post.