Hallo,
ich versuche gerade einen sinnvollen Plot aus einem DBLog zu erstellen, bei dem sich die Werte nur selten ändern.
mysql> select * from history where DEVICE='Nilan' and READING='Output_InletSpeed';
+---------------------+--------+------------+-------------------------+-------------------+-------+------+
| TIMESTAMP | DEVICE | TYPE | EVENT | READING | VALUE | UNIT |
+---------------------+--------+------------+-------------------------+-------------------+-------+------+
| 2017-01-18 22:13:07 | Nilan | MODBUSATTR | Output_InletSpeed: 65 | Output_InletSpeed | 65 | |
| 2017-01-22 15:58:58 | Nilan | MODBUSATTR | Output_InletSpeed: 70.5 | Output_InletSpeed | 70.5 | |
| 2017-01-22 15:59:59 | Nilan | MODBUSATTR | Output_InletSpeed: 100 | Output_InletSpeed | 100 | |
| 2017-01-22 16:21:06 | Nilan | MODBUSATTR | Output_InletSpeed: 65 | Output_InletSpeed | 65 | |
| 2017-01-22 23:30:16 | Nilan | MODBUSATTR | Output_InletSpeed: 100 | Output_InletSpeed | 100 | |
| 2017-01-22 23:45:24 | Nilan | MODBUSATTR | Output_InletSpeed: 65 | Output_InletSpeed | 65 | |
| 2017-01-23 19:23:23 | Nilan | MODBUSATTR | Output_InletSpeed: 100 | Output_InletSpeed | 100 | |
| 2017-01-23 19:39:28 | Nilan | MODBUSATTR | Output_InletSpeed: 73.5 | Output_InletSpeed | 73.5 | |
| 2017-01-23 19:40:29 | Nilan | MODBUSATTR | Output_InletSpeed: 65 | Output_InletSpeed | 65 | |
+---------------------+--------+------------+-------------------------+-------------------+-------+------+
9 rows in set (0.01 sec)
mysql> select * from history where DEVICE='Nilan' and READING='Output_ExhaustSpeed';
+---------------------+--------+------------+---------------------------+---------------------+-------+------+
| TIMESTAMP | DEVICE | TYPE | EVENT | READING | VALUE | UNIT |
+---------------------+--------+------------+---------------------------+---------------------+-------+------+
| 2017-01-18 22:13:07 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 70 | Output_ExhaustSpeed | 70 | |
| 2017-01-22 15:58:59 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 79.5 | Output_ExhaustSpeed | 79.5 | |
| 2017-01-22 15:59:59 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 100 | Output_ExhaustSpeed | 100 | |
| 2017-01-22 16:21:07 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 70 | Output_ExhaustSpeed | 70 | |
| 2017-01-22 23:30:17 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 100 | Output_ExhaustSpeed | 100 | |
| 2017-01-22 23:45:25 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 70 | Output_ExhaustSpeed | 70 | |
| 2017-01-23 19:23:24 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 100 | Output_ExhaustSpeed | 100 | |
| 2017-01-23 19:39:29 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 71.5 | Output_ExhaustSpeed | 71.5 | |
| 2017-01-23 19:40:28 | Nilan | MODBUSATTR | Output_ExhaustSpeed: 70 | Output_ExhaustSpeed | 70 | |
+---------------------+--------+------------+---------------------------+---------------------+-------+------+
9 rows in set (0.00 sec)
Allerdings komme ich dabei zu zwei Problemen:
1. Die Skala fängt immer beim niedrigsten Wert an, ich hätte es gern etwas drunter, damit man die Linie deutlicher sieht.
2. Werte vom Vortag werden nicht dargestellt.
Ich haette gerne steps wobei er eine waagerechte linie malt von einem messwert (egal ob vom vortag) bis zu einem neuen Messwert, von dort dann eine waagerechte Linie auf dem neuen Wert bis ein neuer Wert reinkommt.
Schau dir einmal logProxy an.