Statistics for time aggregated results in JMP

FN — Sat, 25 May 2019 09:12:38 GMT

I have a table with a column that is my time index.

This column is in minutes and I want to calculate statistics aggregating the results but per hour, for example.

How to do that?

Re: Statistics for time aggregated results in JMP

FN — Sat, 25 May 2019 09:33:52 GMT

One way to do this I found:

Tables>Summary and Grouping by Date and Hour (in this order).

To have a column with the complete date, and not splitted by two: include in the Statistics min(Date), being median or max are also possible.

Here is a simpler example aggregating the Lead Production Data table by year.