Hi All,
I have a very simple table containing 2 columns: MDATE, VALUE. The table is populated by an IoT device inserting rows with only 1 or 0. The MDATE column has a trigger with an sysdate.
So, basically I have two columns showing at what time a device has been switched on/off - that's it.
Now, I would like to display that in a chart in some sensible format.
I tried using line charts but I cannot use date as a format for LABEL column (I can use TO_CHAR but then I don' t really see how much time has passed from one entry to another).
Is there an easy way to display a chart where the X-Axis would be based on date/time? In the end I would like to end up with something simmilar to Step Line Chart: Temperature Monitoring System
Regards,
Pawel.