Community Trekker

Joined:

Dec 9, 2016

## 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

Super User

Joined:

Jun 22, 2012

Solution

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

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

Jim

Super User

Joined:

Jun 22, 2012

Solution

## 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
6 REPLIES

Super User

Joined:

Jun 22, 2012

Solution

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

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

Jim

Community Trekker

Joined:

Dec 9, 2016

## 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.

Super User

Joined:

Jun 22, 2012

## 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

Community Trekker

Joined:

Dec 9, 2016

## 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.

Super User

Joined:

Jun 22, 2012

Solution

## 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

Community Trekker

Joined:

Dec 9, 2016

## 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.