I have a timeseries data (float) and another timeseries data (category, state).
Is it possible to display State timeseries data on timeseries chart?
I have a timeseries data (float) and another timeseries data (category, state).
Is it possible to display State timeseries data on timeseries chart?
Probably the simplest would be to modify your SQL query to convert the state into an integer. Alternatively you could do it by script but it would be less efficient. I'd use
-1 = Fault
0 = Off
1 = Running
Then anything above the line is time spent running and anything below the line is time spent in fault.