Swapnil G

Hi, Please find the screenshots attached. As can be seen above, I have multiple conditions with different product names assigned to a property 'Product Name', using .setProperty formula. I then have a signal with different Operation modes (example, Operation mode 1, 2 , 3, etc), which is in string format. I want to export the data on the excel sheet to get following layout: Condition Signal Start End Duration Product 1 Operation Mode 1 10/09/2023 12:28 10/09/2023 12:48 0:20:13 Product 2 Operation Mode 1 11/09/2023 12:28 11/09/2023 12:58 0:30:13 Product 1 Operation Mode 2 12/09/2023 12:28 12/09/2023 13:28 0:60:13 However, when I am trying to extract the data using the Extract to excel option, under 'Signal' column, I am getting signal name 'Operation Modes' instead of actual values as shown below. Condition Signal Start End Duration Product 1 Operation Modes 10/09/2023 12:28 10/09/2023 12:48 0:20:13 Product 2 Operation Modes 11/09/2023 12:28 11/09/2023 12:58 0:30:13 Product 1 Operation Modes 12/09/2023 12:28 12/09/2023 13:28 0:60:13 Hope this helps to understand the question better. Regards, Swapnil Gada

Hi, I have a signal that has the values as string type(created using combinewith() function for combining multiple conditions and their properties). I also have a set of other conditions which I am selecting while exporting to excel. I want to know, for each condition, what is the duration of the capsule and what is the signal value (string value) during that timestamp. When I try to export the above data to excel, it shows the duration for each condition, but under the "Signal" column, just shows the signal name instead of the values. Could you please try and help me resolve this issue? Regards, Swapnil G.

Hi all, I want to create a time weighted mean for the following situation: I want to display value of a signal in table form that aggregates values starting from 8am in the morning and averages the value live for 12 hours. At 20:00, I want the previous 12 hours data to be zero and then restart the averaging of the signal for another 12 hours.

Hi John. This works like a charm. Thanks alot. 🙂

Hi John, thank you for the response. Could you please help me with how can I use this in my example to get shifts aligned and updated with time zones?

Hi all, I am based in the UK and wanted to define shift pattern that changes with time zones. I have created a condition for a 12 hour shifts that are on days for 2 consecutive days and then on nights for 2 consecutive nights. [Each shift will have 4 working days (2 days and 2 nights and 4 days off] Consider 4 shifts in this shift pattern, namely: Shift 1, Shift 2, Shift 3, Shift 4. The shift starts at 8am and ends at 20:00. After which the next shift starts at 20:00 and ends at 8:00 I am using the following formula: In the next step, I am defining my Night Shift using below formula: And then I am defining my Days Shift using below formula: After this, I combined, the days and night condition: $days.union($n) Then I defined my first shift: Shift A: I then moved the next shift by 2 days, Shift B: And then used this shift to define next one and so on, by moving each shift by 2 days from previous one. The issue I am having is that the shift is not aligned with daylight saving. Please help, I referred guide from, but doesn't work for this shift pattern