Tweet
Our factory operates in 3 shifts, and I want to report energy consumption separately for each shift. How can I define shift hours in the SCADA system and filter historical data based on these hours to create shift-based consumption reports? What logic should I use when retrieving this data with an SQL query?
-
-
You can define three different reports for each shift, ensuring that shift supervisors can only access data from their own shift. This can be achieved in two different ways:
1. Method – “Last” Report Type:
Select the report type as “Last” and enter the shift duration into the “Period” parameter. In this way, when the user runs the report at the end of the shift, the system will automatically filter the data for the last shift duration and generate the report output.
2. Method – “Database Query” with Custom SQL:
Select the report type as “Database Query”. Based on the shift time intervals and the relevant tag (ID) information, create an SQL query. This query will filter and return only the data belonging to the specified shift period.
Comment