Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, All
I would like to calculate some values(from PLC data) on specific time range(Excel report).
When I query data from PLC, it shows values with timestamp. Even I can calculate but it is not that meaningful.
Because we need to check whether it is dayoff or not on that time.
So, I would like to select specific time range based on the Excel report, then I hope to calcuate values with PLC data
here are the structures of Two data sets(PLC, Excel)
<PLC data : this value could be ideal time// trouble time>
<Excel report : it shows start time and end time>
Hi, @Anonymous
Not sure what you want.
Can you provide your expected result for further investigation?
Best Regards,
Community Support Team _ Eason
Hi,
Thank you for reply!
I just uploaded some pictures to make it understand better
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |