I am having an issue getting a table data to show what I require.
The main issue is I need to show the Start times and run times etc for each line at each site. And use the time stamp to show the date.
The Start time is Actual Seconds from Midnight and is calculated using DateFormat to convert to the Actual Time. No Date is recorded except the t_stamp
I need to show the start time for each day for the last 4 months.
When I run the Tag queries the Timestamp and data don’t line up correctly.
One option might be to just create a transaction group but I‘d rather not as I’d be just doubling up on Data.
Really what I need is the Data as a lastvalue for each day between the times of 3am and 10pm.