Sending Database to Charts
I found a reply on this discussion Dynamic series identification from message, send data to Chart by Steve-Mcl providing a great solution in the form of a "DB data to chart" function.
I slightly modified this function and still using one function node per data series this works really well. Of course there is a certain clunkiness to running eight queries at startup ...
It would be interesting to know if this function could easily be modified to provide each data series on a separate function node output, or of some other approach to separating the data output to send to different charts.
Reducing the amount of data sent to the charts ...
One advantage of having the eight queries is that it makes it simple to implement some rudimentary data thinning in each query. My initial approach is to use the condition Where ROWID % 20 = 0; in the sql statements which has the effect of selecting every 20th row for the seed data. I just need to tweak so see how many rows I can get off with skipping.
