I will try to expand on this:

I have changed jobNumber to batchNumber to help clarify

There are several plc's , each one at different site. Each has 5 datapoints that we want.
(4 sensors and 1 batchNumber)
Using a modbus datasource, we are retreiving and logging these once per sec into mango on office laptop.
Batch numbers are generated on site so the office has no idea which plc has which batches or when they were done.

batch#, ch1, ch2, ch3, ch4

404 63 67 48 78
404 63 67 48 78

405 63 67 48 78
405 63 67 48 78
405 63 67 48 78
405 63 67 48 78

612 63 67 48 78
612 63 67 48 78
612 63 67 48 78
612 63 67 48 78

on and on every second...

back at the office, the supervisor types in batch number he wants into mango dashboard. This could be a batch from 1 week ago, lets say batch #405.
We need to find the device with #405 on it and put the 4 sensor readings into the serialChart input array for graphical viewing.Keep doing this until a historical graph is built
We have a customized serialChart which views realtime very nicely, but its the historical data that im having trouble with.

hence my request for a query that compares a datapoint value on the plc

Thanks MattFox,

I was able to customize the tab name at the top of web page so I thought i'd give this a shot.

have been getting datapoints for my chart using this:

<ma-point-query query="{$and: true, deviceName:'unit#1_plc', name:'jobNumber'}" limit="9" points="points"></ma-point-query>

but im really wanting the datapoints when "jobNumber=certainValue"

can this be done?

what about on only two devices like: deviceName:'unit#1_plc' or 'unit#2_plc'

hello ,

I have enabled the export on my serialChart. I would like to change the filename that mango assigns to the download and appears at bottom left in the download tab . (ex. "mangoChart 37" change to "my filename 38")

also how to change the text at top of the column in csv report. it currently uses the xid and i have been changing that to something more relevant but was hoping to change it to the name property.

Thanks CraigWeb,

I will watch

this is the graph viewer I have built. I can select the source for each pen. in this case it is showing some data points from a plc. but i can with drop down , select a different source for each pen. The user will want to use this viewer to see datapoints from a mySQL database instead of a plc. Im not sure how to do this but....

i set up a SQL data source with the following :
connection string = jdbc:mysql://localhost:3306/unit1jobdata
driver = com.mysql.jdbc.Driver
Query = select * from testdata1
timestamp overide = assigned to the column containing the timestamp data

the mySQL data is from past jobs

not sure if this helps....

Thanks CraigWeb,

I will get some more info.

I also am now thinking my SQL query may not be right. I m not sure if it should be incrementally getting one row per second or the whole thing .
Right now it is: select * from testfile

Hello,

I have a SQL source set up that connects to a mySQL db file. I have used the test button and I have data being retreived so i feel it is set up correctly. The 1rst column is a time and date stamp then 8 columns of integers. The data was taken once per second so Ive made my query ask for a full row every second. also, ive defined the timestamp as the time overide column(hope thats right).

I have a serialChart that reads these 8 columns but still uses a to/from type date picker to select how long the charts time axis is. I dont know how to get it to use the timestamp from my SQL source as the time axis of the serialchart.

what needs to happen to acheive this?

hello MattFox,

got it finally!
Thanks for checking in.

Hello,

Trying to use the json store demo I found in the docs. Dont seem to get any activity on the result side when entering data into inputs. The markup indicates the retreived data should appear at bottom under save button. Do i need to turn on the json store somewheres?

Ultimately, I need to have a way of saving a set of preferences for several users. These preferences hold their favorite serial chart configuration. (pen color, thickness, min and max scales sources etc.) The Idea is to be able to reload the correct chart config for the correct user once it is determined who they are , or at least let them pick from a saved list of configurations. I have the serial chart ready, just need a way of storing it and retreiving it. Ive also thought a config file or "recipe file" might be an option.

any help would be greatly appreciated.

I have a serial chart with several user settable features. (pen color, thickness etc.)
each user has their own unique settings. can I store these settings and reload them depending on the user . Sort of a "user preferences file " maybe JSONstore?

thanks guys,

here is my reasoning:

I was testing 2 datapoints on 2 different plc. if they were equal, then plc1 would be my source for the seriesChart, if false then plc2. the ng-if was going to help me swap out the devices . I did have a variable that tested the condition and it did evaluate to true or false but when plan didnt work i started to backup and check why.

This supplies my serialChart with 8 dataPoints from my plc and works fine...

<div ng-model="theDevice" ng-init="theDevice='unit#1_plc'" ></div>  

 <ma-point-query query="{$and: true, deviceName:theDevice, name:ptName}" limit="8" points="points"></ma-point-query>
 <ma-point-values points="points" values="combined" from="from" to="to" ></ma-point-values>

This does not... but why not?

<div ng-if="true" ng-model="theDevice" ng-init="theDevice='unit#1_plc'" ></div>  

 <ma-point-query query="{$and: true, deviceName:theDevice, name:ptName}" limit="8" points="points"></ma-point-query>
 <ma-point-values points="points" values="combined" from="from" to="to" ></ma-point-values>

@mattfox said in serial chart lineThickness:

{lineThickness:4}

MattFox,

Thanks for your input. I was missing something simple and now it is working. I spent several hours sifting through AmGraph , AmCharts etc. The example at the top of AmGraph shows "graphs": [ not "graph-options":[ so that threw me off. As far as the API docs, they point to AmGraph with the link , i just missed the hyphen.

The legend="true" is something I learned from the docs and have been using that to show the legend but I was wanting learn how to toggle pens on/off without having the legend on. So far I havent found it.

I always try to read the docs first, but when I spin my wheels for several hours I figure Iv'e missed something simple and should just ask. Reading the threads on this forum exposes you to new ideas from people who have gone through the learning process . I had no Idea that I was wasting peoples time.

in my serial chart there are 8 pens. I need the ability to change the lineThickness of each pen individually. So far i have only been able to change all at once only using :

line-Thickness="4"   ....

I think there must be a way to do this in the Options much like minimum, maximum, axisColor etc.. maybe in valueAxes or amGraph or somewheres like that, but so far i havent got it right.

would also be nice to be able to turn each pen on/off as well using the Options

Thanks MattFox,

I had success using #1 in your reply. I hadnt thought of that.

I cannot get solution #2 to work. I had focused my energy on that way and should have used solution #1

Im trying to put the name property of an array into an input box . The array is same one used to supply data points to a serial chart. it works fine

my code:
<input type="text" ng-model="ch1Name" ng-init="ch1Name={{points[0].name}}" size="10" >

if i use {{points[0].name}} just by itself in a <div> it does display the name property but i want it in an input box.

Thanks MattFox,

So, I created a series-5-axis="right-4" . Then added a 5th part to the valueAxes array like so:
id: 'right-4',
position: 'right',
offset: 100,
axisThickness: 2

everything checks out!

MattFox,

this is how I had been doing it( times 4 as I have 4 pens charting)
series-1-values="point1Values" series-1-point="point1" series-1-type="{{point1ChartType}}" series-1-color="{{point1Color}}" series-1-axis="left"
... of course series 3 and 4 used series-3-axis="left-2" and series-4-axis="right-2"

then, I removed the all the series-x-axis attributes etc. and tried to add the code you suggested from mangoUI dashboard into my valueAxes array.

Thanks for the help!

Unfortunately I cant seem to get past the 4 , and i had to go back to using
series-x-axis="left-2" and etc. to make it work. I was not able to get the additional parameters in the valueAxes array to work.

as for the check in the code, my javascript skill is there yet.