How to align the time in different charts in one dashboard?

General
1

Hi,
I have data in several MYSQL tables. when I get the data out and plot to the charts, because the Timestamp in each table are not the same, the starting time and range are not the same.
e.g.
newMsg.topic = "SELECT * from table1 where Time > '" + newTime + "' LIMIT 2000;";
newMsg.topic = "SELECT * from table2 where Time > '" + newTime + "' LIMIT 2000;";
Is there any way I can align the time of all chart? Thxchart

2

I haven't tried it, but if you add an extra sample to the end of the one that is behind, with a timestamp the same as the last one from the other chart then that will align the right hand sides. If you use a value of null then it won't actually draw the line to the end. Similarly you can do the same for left hand end by adding a null sample on the front.
As I said I haven't tried it but worth a go.

3

Thx but... Making fake data seems not right... 'Coz a line would be drawn to/from the fake points too.

4

Not if the fake data is null

5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.