Forum Discussion
Multiple data aggregating | datetime and group
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 n...
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?