BookmarkSubscribe
Choose Language Hide Translation Bar
FN
FN
Contributor

Statistics for time aggregated results in JMP

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?

 

0 Kudos
1 REPLY 1
FN
FN
Contributor

Re: Statistics for time aggregated results in JMP

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.

jmp_aggregation.png