Forum Discussion
Two dates in table (start and end time) and aggregate data per day
Hi, I really appreciate if someone can help. Imagine there is a plant which works 24 hours with 12 hours shifts staring at 6AM/PM. In this situation the “Production day” is different from calend...
Hi Mehrnoosh ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
Hi Anonymous
I need to show the number of downtimes per production days and the hours the equipments where stopped per production day.
The result will be similar to this for my above example
| Production Day (6 AM to 6 AM) | Number of Downtimes | Hours Down(hours) |
| 1/1/20 | 3 | 27 |
| 2/1/20 | 2 | 25 |
| 3/1/20 | 1 | 2 |
Hi Mehrnoosh ,
Could you please give a calculate logic about your demands? An example would be better.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu