cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
mallen810
Level III

Daily Average and Max and Min for a given date

I am importing sql data for our server and there can me several readings on any given day. I want to be able to get the daily average, max and min for a given day. If possible I would like to graph the data in this way also. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

Re: Daily Average and Max and Min for a given date

After reading your data into JMP, you can run

     Analyze==>Tabulate

to get the report table you asked for 

Mallen810a.GIF

And then to get the graph

     Graph==>Graph Builder

to generate box plots, that show the distribution for each date

mallen810b.GIFDocumentation you should look at is located under the Help pull down menu

     Help==>Books==>Using JMP

and

     Help==>Books==>Essential Graphing

Jim

View solution in original post

txnelson
Super User

Re: Daily Average and Max and Min for a given date

Make sure the format specified is for a Date format, and not a DateTime format.  And If necessary, create a new column with a formula pulling out only the date part of your column, and then use it as the column in the tabulate.

If you attach your jmp table to your response, I will take a look at it.

Jim

View solution in original post

6 REPLIES 6
txnelson
Super User

Re: Daily Average and Max and Min for a given date

After reading your data into JMP, you can run

     Analyze==>Tabulate

to get the report table you asked for 

Mallen810a.GIF

And then to get the graph

     Graph==>Graph Builder

to generate box plots, that show the distribution for each date

mallen810b.GIFDocumentation you should look at is located under the Help pull down menu

     Help==>Books==>Using JMP

and

     Help==>Books==>Essential Graphing

Jim
mallen810
Level III

Re: Daily Average and Max and Min for a given date

Tabulate only give me the average for all the data and not for individual days.


txnelson
Super User

Re: Daily Average and Max and Min for a given date

You need to change the Modeling Type of your date column from Continuous to Ordinal

Jim
mallen810
Level III

Re: Daily Average and Max and Min for a given date

I changed the modeling but still returning more than one average number per day.
txnelson
Super User

Re: Daily Average and Max and Min for a given date

Make sure the format specified is for a Date format, and not a DateTime format.  And If necessary, create a new column with a formula pulling out only the date part of your column, and then use it as the column in the tabulate.

If you attach your jmp table to your response, I will take a look at it.

Jim
mallen810
Level III

Re: Daily Average and Max and Min for a given date

Thanks, when I mad new column and extracted only the date it worked perfect.