Exporting Discrete Data to OData Feed

[Alex Aydell]

I have numerous discrete datapoints in Seeq that I would like to export via the Odata option to powerbi with the original timestamps for each datapoint.  I see this option for exporting to Excel, but not Odata?

 

Is there a workaround to accomplish this?

Best,

Alex

[Kin How]

The "Samples table grid" has "Ungridded original timestamps" added as an option in R63. You will see this option after upgrading to R63. 

https://support.seeq.com/kb/latest/cloud/odata-export

[Selmane]

You can also convert your signal interpolation to step using the tostep() formula:

$signal.tostep(1d)

with 1 day being the max interpolation for the signal. You can make it longer or shorter according to the frequency of your signal. The step-interpolated signals can be exported to OData before the enhancement shared by Kin How above.

[Alex Aydell]

Yeah I was intentionally having .todiscrete data on some aggregated data and wanted to avoid the stepwise signal.  I will see if our group can upgrade our system to R63 in the near future.

Thank you.

[Thorsten Vogt]

Hi Alex,

maybe one workaround you could try is creating capsules for the discrete signal using $signal.tocapsules(). The capsules do not have duration, but will contain the value of the signal in a capsule property. Then export the Condition using OData and use the OData Capsule Summary Table Endpoint. I do not have Power BI, but when loading the data to Excel I can see the start of the capsule and the corresponding value. So this might be the information you can use.

Regards,

Thorsten