Subscribe Bookmark RSS Feed

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

mallen810

Contributor

Joined:

Dec 9, 2016

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

Joined:

Jun 22, 2012

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

Jim
txnelson

Super User

Joined:

Jun 22, 2012

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.

Jim
6 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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

Jim
mallen810

Contributor

Joined:

Dec 9, 2016

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


txnelson

Super User

Joined:

Jun 22, 2012

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

Jim
mallen810

Contributor

Joined:

Dec 9, 2016

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

Super User

Joined:

Jun 22, 2012

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.

Jim
Highlighted
mallen810

Contributor

Joined:

Dec 9, 2016

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