Signal values of type String are not exporting to excel

[Swapnil G]

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.

[Selmane]

Hello Swapnil,

I think some screenshots would be interesting here. Question for you: which tool/formula are you using to get the signal value during that timestamp? Is it working well in workbench? Is the problem only when you export to Excel? Can you share a screenshot of the Excel document?

For more in-depth support, I suggest you create a support ticket on https://support.seeq.com or attend an Office Hours session.

Thanks,

--Selmane

[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

Edited January 17 by Swapnil G