47055_en-US

liliconcom

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. 

Re: Daily Average and Max and Min for a given dateThanks, when I mad new column and extracted only the date it worked perfect.
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.

Re: Daily Average and Max and Min for a given dateI changed the modeling but still returning more than one average number per day.
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

Re: Daily Average and Max and Min for a given dateTabulate only give me the average for all the data and not for individual days.


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 

And then to get the graph

     Graph==>Graph Builder

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

Documentation you should look at is located under the Help pull down menu

     Help==>Books==>Using JMP

and

     Help==>Books==>Essential Graphing