Page 26 of 28

Re: Highcharts Graphs

Posted: Tue 28 Apr 2020 9:10 am
by dazza1223
ive pm u if u want a hand?

Re: Highcharts Graphs

Posted: Sun 10 May 2020 12:37 pm
by Sadgit
Thank you to Dazza. I am up and running now, however on the Historic graphs I am cannot go beyond 18th April 2020. Anyone know why please?
1804.PNG

Re: Highcharts Graphs

Posted: Sun 10 May 2020 2:07 pm
by Mapantz
Hi Mark

Could you provide a link so we can take a look?!

Re: Highcharts Graphs

Posted: Sun 10 May 2020 5:06 pm
by Sadgit
sure and thanks

http://www.marton-weather.co.uk/testing ... storic.php

It is very much in a test phase as I am totally new to designing a site and have used a lot of ideas from yours (which I truly love) and Mark's. Mainly for ideas on how css works, which I am still struggling with :D

Re: Highcharts Graphs

Posted: Sun 10 May 2020 8:39 pm
by Mapantz
Humidity and pressure are up to date, so it might be a problem with data missing in some of the other columns of your database?

Click 'By Mon & Hr'

You'll see an error, so something must be up with dates/data.

Re: Highcharts Graphs

Posted: Mon 11 May 2020 6:08 am
by Sadgit
Thanks. I had checked the DB but couldnt see anything odd.. today it shows the latest date of 19th, yesterday was 18th.. hmmm

The day file matches up with the data in the DB but not with the charts... I am missing several days early this year as I have my station off for maintenance.. well about 2 weeks worth in total. The charts on those dates have data showing.... don't tell me I need to go and add fake data in ? :D

EDIT, yep due to missing data over the years..god dammit!

Re: Highcharts Graphs

Posted: Mon 11 May 2020 9:23 am
by dazza1223
hey yes i did say to you u have a lote off data missing!! and i said when i fist got them chart up and running i found out i had a hell off data missing and what i did was went on weather underground ner bye station and got some off the data what was close to me and put in the data like that it the olny way u can do this.... how long dose ur data go bk to ? if it not to long just start fresh?

Re: Highcharts Graphs

Posted: Mon 11 May 2020 9:52 am
by Sadgit
2013 :D no way am I starting again !

I can use the NOAA data to find the missing days and good tip about Wunderground! Thanks!

Re: Highcharts Graphs

Posted: Mon 11 May 2020 9:58 am
by dazza1223
but if u use that in that inport scirp what mark made then u can see what sort off data is missing then u go from there ;)

Re: Highcharts Graphs

Posted: Sun 07 Jun 2020 6:38 pm
by DeleriusWeather
Hello All.

I have copied this script and implemented in to my website cos I have found that these highcharts are much more superior than the cumulus trends. (thanks Mark Crossely) I currently have the rolling 24 hour trends running on my website but cannot get the historic charts to populate.

I have read through this thread 3 times and I cannot get my graphs to show. Chart keeps throwing out an 'Oops...Failed to load the chart' error. My data files are creating the json files as shown in the attached JPG file but I cannot find the problem in the script. :groan: :bash:

Any help would be helpful... the page that needs the help is www.delerius-weather.com/historic_charts.php. :oops:

Thanks

Lee

Re: Highcharts Graphs

Posted: Sun 07 Jun 2020 8:21 pm
by Mapantz
Press F12 and click 'console'

You have quite a few errors..

You should go through them one-by-one

Re: Highcharts Graphs

Posted: Mon 08 Jun 2020 8:15 pm
by DeleriusWeather
Thanks for the help Mapantz... Ive managed to get the majority of the graphs working... just one or 2 tweaks left...

Many Thanks :D :D

Re: Highcharts Graphs

Posted: Tue 09 Jun 2020 10:46 am
by stewartwlewis
I love these highcharts graphs and have been working on implementing them on my weather site. I have got most of them working except for the Temperature Comfort chart. It uses a separate table which I presume is populated with the % of time each days temperature is within the bands via a SQL insert statement from the monthly table. Could someone let me have a copy of the comfort table structure and the SQL statement that generates it.
The Insolation charts are I think similar and it would be great if somebody could let me have a copy of the dailyInsolation table structure and SQL statement that generates it.
My SQL skills are very basic and I just can’t work out how they are done but I have already learned a whole lot by understanding how the other charts are constructed.

Re: Highcharts Graphs

Posted: Thu 13 Aug 2020 9:58 am
by peterjreid61
Sorry for posting in an old thread. I've look everywhere and haven't found anything yet.I'm running MX 3090 at present.
I am trying to get hold of how the temp by month/hour and Comfort tables are populated.
The SQL queries are calling tables that I don't have in my DB and cant find anywhere to configure the table structure and the SQL inserts or otherwise.
Can someone point me at where I might find this information.

Re: Highcharts Graphs

Posted: Thu 13 Aug 2020 11:34 pm
by Mapantz
I think there's a bug with the historic charts - the monthly high/lows. The average min's / max's don't seem to match up with other graphs or the data summary.