topic Re: Daily Average and Max and Min for a given date in Discussions

Daily Average and Max and Min for a given date

mallen810 — Fri, 10 Nov 2017 15:39:55 GMT

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 date

txnelson — Fri, 10 Nov 2017 16:16:37 GMT

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

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

mallen810 — Fri, 10 Nov 2017 16:20:59 GMT

Tabulate 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

txnelson — Fri, 10 Nov 2017 16:28:39 GMT

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 date

mallen810 — Fri, 10 Nov 2017 17:14:59 GMT

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

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

txnelson — Fri, 10 Nov 2017 17:20:53 GMT

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 date

mallen810 — Fri, 10 Nov 2017 17:26:59 GMT

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