Forum Discussion
Helper VVisual to show when machine stop and run
Hi Expert, I have trouble to create visual like above (Status history) to show how long a stoppage happens. Red means that machine stop, green means that machine run.
Scenario:
In my stoppages table, I have dt_startand dt_stop of a stoppages. Based on that, I will have stoppages minutes per stoppage category per machine. Is it possible to have visual like above based on what I have?
What I have now:
The x-axis is the date time, the y-axis is the minutes. But I don't want like this. It should be like in the top visual.
My example table:
1 Reply
- Ritaf1983
Super User
Hi New_be
The closest visual to the desired is a heatmap like mine in the picture:in your case, there is 1 row because of 1 machine and the values are 1/0 for run/stop.
To get it possible you should get a table by
Date, time, status .
Take a look at the linked blog post about how to split it:End-to-end solution here is a few hours for me so unfortunately I can't demonstrate, but I hope I was able to give you the direction.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
