Charts? Add sensor

Author	Message
krzyszp Project administrator Project developer Project tester Project scientist Send message Joined: 16 Apr 11 Posts: 383 Credit: 785,937 RAC: 144	Message 791 - Posted: 29 Feb 2012 \| 0:22:13 UTC Last modified: 17 Jun 2012 \| 20:27:19 UTC
Hi, I have prepared new simple chart. It's still in progress, but maybe anybody want to use it? Link is in format: http://192.166.218.170/scripts/wykres.php?ID=2444 where ID is ID for your detector... If anybody would like to try his own chart library, query to load hourly average measurements (last 24h) from particular detector is: SELECT DATE_FORMAT(data, '%d/%c/%Y %H') AS data, (AVG(pomiar_raw) / AVG(czas_pomiaru)/171.232876) as pomiar FROM trickles_lite WHERE hostid = $host AND data >= NOW() - INTERVAL 24 HOUR GROUP BY DATE_FORMAT(data, '%d/%c/%Y %H') ORDER BY data ASC Table structure: CREATE TABLE trickles_lite ( id int(11) NOT NULL AUTO_INCREMENT, hostid int(11) DEFAULT NULL, pomiar_raw int(11) DEFAULT NULL, `data` datetime DEFAULT NULL, loc1 float(10,6) DEFAULT NULL, loc2 float(10,6) DEFAULT NULL, czas_pomiaru float(10,3) DEFAULT NULL, typ_pomiaru char(1) DEFAULT NULL, eksperyment tinyint(4) DEFAULT NULL, PRIMARY KEY (id), KEY data_index (`data`), KEY host_data_index (hostid,`data`), KEY eksperyment (eksperyment), KEY hostid (hostid) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Enjoy :) ____________ Regards, Krzysztof 'krzyszp' Piszczek Android Radioactive@Home Map Android Radioactive@Home Map - donated My Workplace
ID: 791 \| Rating: 0 \| rate: / Reply Quote

FogBRD Send message Joined: 16 Feb 12 Posts: 22 Credit: 6,008 RAC: 0	Message 795 - Posted: 29 Feb 2012 \| 8:46:57 UTC - in response to Message 791.
All right. only need another small picture size of a banner - which can be inserted into the signature on the forum and website. ____________
ID: 795 \| Rating: 0 \| rate: / Reply Quote

WetterYbbs Send message Joined: 15 Mar 12 Posts: 9 Credit: 349,735 RAC: 0	Message 869 - Posted: 16 Mar 2012 \| 10:24:36 UTC Last modified: 16 Mar 2012 \| 10:28:44 UTC
Hello That´s cool what this time on Charts UTC? ____________
ID: 869 \| Rating: 0 \| rate: / Reply Quote

WetterYbbs Send message Joined: 15 Mar 12 Posts: 9 Credit: 349,735 RAC: 0	Message 947 - Posted: 1 Apr 2012 \| 8:27:55 UTC
Hallo Wäre es nicht besser das ganze über ORDER BY id DESC zu machen? So mit würde das bei Monat wechsel auch stimmen! lg, Wolfgang ____________
ID: 947 \| Rating: 0 \| rate: / Reply Quote

krzyszp Project administrator Project developer Project tester Project scientist Send message Joined: 16 Apr 11 Posts: 383 Credit: 785,937 RAC: 144	Message 957 - Posted: 4 Apr 2012 \| 16:01:52 UTC - in response to Message 947.
Can you (or anybody) translate to English, please? As google translator are not very good know German, I can't really understand... In query above you can change INTERVAL to any period (just you get more points in chart). Playing with just ID didn't get you right results (but I didn't check this). ____________ Regards, Krzysztof 'krzyszp' Piszczek Android Radioactive@Home Map Android Radioactive@Home Map - donated My Workplace
ID: 957 \| Rating: 0 \| rate: / Reply Quote

Saenger Send message Joined: 16 Jun 11 Posts: 165 Credit: 633,917 RAC: 135	Message 958 - Posted: 4 Apr 2012 \| 18:22:31 UTC - in response to Message 947.
Hallo Wäre es nicht besser das ganze über ORDER BY id DESC zu machen? So mit würde das bei Monat wechsel auch stimmen! lg, Wolfgang I'll try: Wouldn't it be better to do that with ORDER BY id DESC? It should even work correct with data over two months. ____________ Gruesse vom Saenger
ID: 958 \| Rating: 0 \| rate: / Reply Quote

WetterYbbs Send message Joined: 15 Mar 12 Posts: 9 Credit: 349,735 RAC: 0	Message 961 - Posted: 6 Apr 2012 \| 19:26:02 UTC Last modified: 6 Apr 2012 \| 19:28:11 UTC
Danke Sänger Thank you Sänger Excuse my english writing is not good, I understand it already lg, Wolfgang ____________
ID: 961 \| Rating: 0 \| rate: / Reply Quote

Author

Message

krzyszp
Project administrator
Project developer
Project tester
Project scientist
Avatar

Send message
Joined: 16 Apr 11
Posts: 383
Credit: 785,937
RAC: 144

Hi, I have prepared new simple chart.
It's still in progress, but maybe anybody want to use it?

Link is in format:

http://192.166.218.170/scripts/wykres.php?ID=2444

where ID is ID for your detector...

If anybody would like to try his own chart library, query to load hourly average measurements (last 24h) from particular detector is:

SELECT DATE_FORMAT(data, '%d/%c/%Y %H') AS data,
(AVG(pomiar_raw) / AVG(czas_pomiaru)/171.232876) as pomiar
FROM trickles_lite
WHERE hostid = $host AND data >= NOW() - INTERVAL 24 HOUR
GROUP BY
DATE_FORMAT(data, '%d/%c/%Y %H') ORDER BY data ASC

Table structure:

CREATE TABLE trickles_lite (
id int(11) NOT NULL AUTO_INCREMENT,
hostid int(11) DEFAULT NULL,
pomiar_raw int(11) DEFAULT NULL,
`data` datetime DEFAULT NULL,
loc1 float(10,6) DEFAULT NULL,
loc2 float(10,6) DEFAULT NULL,
czas_pomiaru float(10,3) DEFAULT NULL,
typ_pomiaru char(1) DEFAULT NULL,
eksperyment tinyint(4) DEFAULT NULL,
PRIMARY KEY (id),
KEY data_index (`data`),
KEY host_data_index (hostid,`data`),
KEY eksperyment (eksperyment),
KEY hostid (hostid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Enjoy :)
____________
Regards,
Krzysztof 'krzyszp' Piszczek
Android Radioactive@Home Map
Android Radioactive@Home Map - donated
My Workplace

ID: 791 | Rating: 0 | rate:

Reply Quote

FogBRD
Send message
Joined: 16 Feb 12
Posts: 22
Credit: 6,008
RAC: 0

All right. only need another small picture size of a banner - which can be inserted into the signature on the forum and website.
____________

ID: 795 | Rating: 0 | rate:

Reply Quote

WetterYbbs
Send message
Joined: 15 Mar 12
Posts: 9
Credit: 349,735
RAC: 0

Hello

That´s cool what this time on Charts UTC?
____________

ID: 869 | Rating: 0 | rate:

Reply Quote

WetterYbbs
Send message
Joined: 15 Mar 12
Posts: 9
Credit: 349,735
RAC: 0

Hallo

Wäre es nicht besser das ganze über ORDER BY id DESC zu machen? So mit würde das bei Monat wechsel auch stimmen!

lg,
Wolfgang
____________

ID: 947 | Rating: 0 | rate:

Reply Quote

krzyszp
Project administrator
Project developer
Project tester
Project scientist
Avatar

Send message
Joined: 16 Apr 11
Posts: 383
Credit: 785,937
RAC: 144

Can you (or anybody) translate to English, please? As google translator are not very good know German, I can't really understand...
In query above you can change INTERVAL to any period (just you get more points in chart).
Playing with just ID didn't get you right results (but I didn't check this).
____________
Regards,
Krzysztof 'krzyszp' Piszczek
Android Radioactive@Home Map
Android Radioactive@Home Map - donated
My Workplace

ID: 957 | Rating: 0 | rate:

Reply Quote

Saenger
Send message
Joined: 16 Jun 11
Posts: 165
Credit: 633,917
RAC: 135

Hallo

Wäre es nicht besser das ganze über ORDER BY id DESC zu machen? So mit würde das bei Monat wechsel auch stimmen!

lg,
Wolfgang

I'll try:

Wouldn't it be better to do that with ORDER BY id DESC? It should even work correct with data over two months.
____________
Gruesse vom Saenger

ID: 958 | Rating: 0 | rate:

Reply Quote

WetterYbbs
Send message
Joined: 15 Mar 12
Posts: 9
Credit: 349,735
RAC: 0

Danke Sänger

Thank you Sänger
Excuse my english writing is not good, I understand it already

lg,
Wolfgang
____________

ID: 961 | Rating: 0 | rate:

Reply Quote