ThingSpeak Live Chart, multi channel, second axis, historical data, csv export | Announcements | Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
ThingSpeak Live Chart, multi channel, second axis, historical data, csv export
January 24, 2014
5:43 pm
Avatar
turgo

Forum Posts: 53
sp_UserOfflineSmall Offline

Here is a HTML JavaScript web page to display multiple series and channels in real time.
http://forum.arduino.cc/index.php?action=dlattach;topic=213058.0;attach=66726
http://forum.arduino.cc/index.php?action=dlattach;topic=213058.0;attach=66752Image Enlarger

You must edit the page source/ JavaScript to enter your channel information.

If you have lots of series, it is helpful to click the "Hide All" button, and then click on the series names you are interested in to show them. Clicking and dragging vertically on the chart will select a range to zoom in to.

Check the "Update Chart" checkbox to enable realtime charting. With more than about 8 channels, this causes ThingSpeak to cache and delay the data, so I have it unchecked.

It also features buttons to load historical data 8000 points at a time. Select which channel you want to load, and how many sequential loads to try. Then click the "Load More Historical Data" button. Loading too much data causes ThingSpeak to first delay the data, and then (error 404) refuse to return data. After ten loads or so, I often cannot load any more data.

The three bars export button at the top right has an option to download a .csv file containing the data from the chart.

This is public domain. Please post upgrades on the Arduino forum thread. (too bad this forum doesn't support posting files)
http://forum.arduino.cc/index.php?topic=213058.0

The navigator could be dramatically upgraded to provide complete access to your historical data with smaller data downloads if ioBridge were to change the Average function so it would return 8000 points, instead of averaging 8000 points. http://community.thingspeak.com/forum/thingspeak-api/daily-average1440-parameter-purpose-defeated-by-results-limits/

The charting library is called HighStock. It is awesome! HighSoft, the owners say, "Do you want to use Highstock for a personal or non-profit project? Then you can use Highchcarts for free under the Creative Commons Attribution-NonCommercial 3.0 License. "

September 5, 2014
4:06 am
Avatar
ntallari
Forum Posts: 1
sp_UserOfflineSmall Offline

Holy Crap! This is absolutely wonderful! It's exactly what i've been looking for! I'm using it for my student lab webpage. I hope that's alright. Thank you thank you.

September 22, 2014
10:35 pm
Avatar
turgo

Forum Posts: 53
sp_UserOfflineSmall Offline

My pleasure. If you make upgrades, please share them.

December 26, 2014
10:53 am
Avatar
geo3geo

Forum Posts: 9
sp_UserOfflineSmall Offline

Many thanks turgo for sharing your work.
I've just used it for my composite BeeBug monitor display
- see http://www.mecol.co.uk/P11.php
Cheers!
Geo

April 14, 2015
8:14 pm
Avatar
turgo

Forum Posts: 53
sp_UserOfflineSmall Offline

Cool, Geo.

I'm most interested in the weight stat. It's interesting to consider how it measures when the bees are home or out working. What is the Brood measure?

January 10, 2016
11:19 am
Avatar
gabrielb

Forum Posts: 8
sp_UserOfflineSmall Offline

I think i have discovered a problem with this FANTASTIC viewer.
First off, I absolutely love it...

The problem I've found is that it does not handle channels higher than 65535.
That number does look familiar doesn't it? (Hint: hFFFF)

If i keep my viewed channels low, it works fine, but if i have a channels starting with 7 it mixes up the graphs, things fail.. etc.

I think i Know what the problem is but i have no idea about HTML and JAVA, so I havent been able to fix it.
Variable "channelNumber" seems to be the problem but i cant find where its initialized on the code...

A fix for this would be GREATLY appreciated.

regards,
G.

February 5, 2016
10:19 am
Avatar
vorms

Forum Posts: 7
sp_UserOfflineSmall Offline

Hello
I use the turgo script for 2 applications.
For the first one it work very well.
For the second, depending the lengh of historic, data is not displayed.
If you display the last week the display is right.
If you try to display the last day there is no data.
Every days, ther is no data from 23 PM to 6 AM, that just normal.
May be it is a problem on Thingspeak ?
The data on thingspeak is ok
Thie link for the dispay is here:
http://thili.net/ruches/Blaise/index.html

what is very stange is if I dowlload data or create csv file, data seasm to be good ...

Many thanks for your help and thanks again for your very nice script !!!

Thierry Vorms

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
13 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 168

vespapierre: 63

chrisjmears: 54

turgo: 53

CorBee: 37

Rob Purser: 36

Member Stats:

Guest Posters: 1

Members: 4840

Moderators: 0

Admins: 2

Forum Stats:

Groups: 4

Forums: 17

Topics: 926

Posts: 3318

Newest Members:

al1fch, strangeloop, acenhat, AdamSy, alexleandrom, samira

Administrators: Hans: 341, lee: 457