Page 2 of 3

Re: Custom Web Chart

Posted: Sun Sep 07, 2014 9:48 pm
by arch
rimai wrote:We would need to analyze the results of the query record by record to be able to do this.
Remember that this is a SQL query.
I've had a bash at doing this in javascript. I haven't tried it with highcharts yet, but it works with a my modified version of your webcharts using d3.

See http://arch1.github.io/RA_CustomCharts/

and

https://github.com/arch1/RA_CustomCharts


The RFW plot is a good example of plotting data gaps.

Re: Custom Web Chart

Posted: Tue Sep 09, 2014 1:37 pm
by lnevo
Very nice. The only thing you're missing is the mouse-overs to see the details.

Re: Custom Web Chart

Posted: Tue Sep 09, 2014 7:25 pm
by arch
Yes - I'll put on that on the todo list (along with plotting individual relays - maths was easier than I thought it would be).

I've made the charts scrollable in this version (still needs a bit of tidying up - but tooltips shouldn't be too hard):

http://bl.ocks.org/arch1/5c63a184ca638b291df7

(best viewed in new window)

Re: Custom Web Chart

Posted: Tue Sep 09, 2014 8:14 pm
by lnevo
That is really cool. Can we overlap multiple filters? Thanks for showing the HTML in that. I was able to copy that over to my server and switch it to my ID. FYI Celsius to Fahrenheit was a pain but not too bad.

Re: Custom Web Chart

Posted: Tue Sep 09, 2014 8:51 pm
by arch
I'm planning to add multiple filters - but it will take me a while - this is already a major stretch of my javascript/d3 capabilities.

While there are plenty of examples around ( http://bl.ocks.org/mbostock/3884955, http://www.d3noob.org/2014/07/d3js-mult ... matic.html) adding extra features without breaking existing ones is proving a challenge...

Re: Custom Web Chart

Posted: Thu Sep 11, 2014 1:26 am
by arch
lnevo wrote:Isnt the chart software javascript? Couldn't you massage the result of R and OR it in the js before you process the chart? Another way would be to have a separate js/php/ whatever vb..net i think that would break R up in a usable format.

The problem for me is I dont follow how the graphs get the data :)

But I'm sure we can get some json/xml/output to do it, or am I missing something?
Here's my first crack at plotting individual relay data from the decimal representation:

http://bl.ocks.org/arch1/9178a77aea3d5775897a

the plotting code isn't very elegant yet (it's hard-coded to main relay and expansion relay box only) - but seems to work OK (with data gaps dealt with too).

Re: Custom Web Chart

Posted: Thu Sep 11, 2014 3:25 am
by lnevo
Awesome

Re: Custom Web Chart

Posted: Thu Sep 11, 2014 4:23 am
by arch
AlanM wrote:Right. Is it because you use highstock.js instead of highchart.js? I wouldn't think so, though. Weird.
I can't work out how highcharts deal with irregular data either. Others have lobbied so far ? unsuccessfully for changes re data gaps:
http://forum.highcharts.com/highstock-u ... age15.html

Re: Custom Web Chart

Posted: Thu Sep 11, 2014 7:17 pm
by arch
lnevo wrote:Very nice. The only thing you're missing is the mouse-overs to see the details.
Tooltips added in this version (I'm sure this code could be written in a fraction of the number of lines).

http://bl.ocks.org/arch1/d220e06fc3dcc4ea6d82

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 7:34 am
by saf1
Not sure I understand how the portal charts are supposed to work. I wanted to see how the wave maker was working with regards to my tide code and both PWMA and PWMD are both showing activity - or something with regards to plots in the chart.

Yet on the tank I can clearly see only one RW spinning up and the PWM D at 65% while the PWM A is at 0. What is the web chart actually plotting or do I need to enable something else. I was trying to see if it actually slowed down at night and if the left and right side alternated and at what time. Now I'm totally lost :)

Thanks.
-scott

http://forum.reefangel.com/status/chart ... ilter=PWMA
http://forum.reefangel.com/status/chart ... ilter=PWMD

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 9:10 am
by rimai
The portal plots data every 5 minutes.
For fast wavemaking, you won't be able to see it in the chart.

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 9:28 am
by saf1
rimai wrote:The portal plots data every 5 minutes.
For fast wavemaking, you won't be able to see it in the chart.
Ok. That makes sense. However, what I am seeing is both PWM A and D showing data and/or a pattern when the ReefAngel Client and physical RW in question is off. I'm not sure what data it is actually plotting then.

The tide code I have running now is:
if (tide.isIncoming()) {
ReefAngel.DCPump.DaylightChannel = None;
ReefAngel.DCPump.ActinicChannel = AntiSync;
}
else {
ReefAngel.DCPump.DaylightChannel = AntiSync;
ReefAngel.DCPump.ActinicChannel = None;
}

Then under the ///// Place your custom code below here I have:
ReefAngel.DCPump.SetMode( ReefCrest,45,10 );

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 9:45 am
by rimai
It's plotting the reefcrest wave form.
It is a random waveform, just like what you see in the chart.
Every 5 minutes, the controller sends data. Whatever happens in between those 5 minutes won't be shown in the chart.

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 2:34 pm
by saf1
rimai wrote:It's plotting the reefcrest wave form.
It is a random waveform, just like what you see in the chart.
Every 5 minutes, the controller sends data. Whatever happens in between those 5 minutes won't be shown in the chart.
Ok, I understand that. I guess the error is on my part somewhere then because what I was trying to figure out is why the graphs for PWM A and D are both showing data when only one is actually running. In this case PWM D.

I was assuming that tide.isIncoming with the if/else would power PWM D and have A set to off (that is actually what is running now). Then when the tide is outgoing it would swap D to off and A to on. So when I saw the graphs showing data for both it didn't make any sense to me. I've also only seen the PWM D running using this function so clearly I have something wrong.

Back to the drawing board :)

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 3:34 pm
by rimai
Ahh. Now I understand what you were asking.
The reason I think you are not getting a true representation of what is happening is because the graph won't lot zeros.
If you look at the chart for PWMA, the last plot was Thursday 1:45pm and then, it jumps to Friday 3:05pm. It doesn't show the zeros for that time frame in between.

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 3:39 pm
by saf1
rimai wrote:Ahh. Now I understand what you were asking.
The reason I think you are not getting a true representation of what is happening is because the graph won't lot zeros.
If you look at the chart for PWMA, the last plot was Thursday 1:45pm and then, it jumps to Friday 3:05pm. It doesn't show the zeros for that time frame in between.
Ok, that makes sense(the light bulb light :) ). And sorry that I wasn't clear in asking the question.

Re: Custom Web Chart

Posted: Fri Aug 21, 2015 4:52 pm
by saf1
Actually, I think I have another error looking back at my code. If I set the ReefAngel.DCPump.DaylightChannel = None, that is applying no PWM signal, or 0(?)? Reading various threads today it appears the general thought is to leave them at 25 or so percent power?

If I truly wanted high and low tide or only one side performing the actual pattern then I'd probably need to disable/enable the relay box port with power. Or go back and use AntiSync/Sync unless the tidalSwell power it back up from 0.

Re: Custom Web Chart

Posted: Fri Jan 22, 2016 11:34 pm
by lnevo
Is there a URL I can use to get the Relay Data chart? Right now I'm using the filter R1 but would like to embed the Relay Data one that's on the portal instead.

Re: Custom Web Chart

Posted: Sat Jan 23, 2016 11:51 am
by rimai
Not yet.
Let me see if I can get that done.

Re: Custom Web Chart

Posted: Fri Feb 19, 2016 9:19 pm
by rimai
See if it works now.
I added the ability to get single relays.
Use filter relayxy, where x is the relay box and the y is the port.
Examples:
relay2 - Main Box relay 2
relay15 - Exp Box 1 relay 5

Re: Custom Web Chart

Posted: Sat Feb 20, 2016 6:08 am
by lnevo
Very nice