Multiple data aggregating | datetime and group

[obartok]

Hello,
I'm trying to create a report from the data I have from the machines. Each row represents a specific time period, which is created at regular periods (15min) or when it changes.

I would need to aggregate these time periods so that I can present the RUN/DOWN time periods and for DOWN also its type. See image.

I thought of the possibility of indexing and when the data changes (machine state or downtime type).

Currently the data is presented without the ability to time events. When if DOWN occurred 2 times at 6:00 - 6:02 and then 8:15-8:20 the table will show DOWN data - 6:00 - 8:20 - 7 minutes. What is wrong.

Thank you for all your ideas.

[Anonymous]

Hi @obartok ,

Please share some sample data in text format so that we can use it to create a demo.

Best Regards,

Jay

[SebSchoon1]

Hello,

If you do End Date - Start Date in a columns called "Time difference"

Then unpivot everything but not  Run and Down Column. 

This should create the Work Type column

Then Group by the levels you want,

ID - Work Type - Down Type . 

Then aggregate Count and Time difference?