Daily Average and Max and Min for a given date

[#1]

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 solution]

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

[#3]

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

[#4]

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

[#5]

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

[#6 · Accepted solution]

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.

[#7]

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