Alex Aydell Posted December 4, 2023 Share Posted December 4, 2023 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 Link to comment Share on other sites More sharing options...
Seeq Team Kin How Posted December 5, 2023 Seeq Team Share Posted December 5, 2023 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 1 Link to comment Share on other sites More sharing options...
Seeq Team Selmane Posted December 5, 2023 Seeq Team Share Posted December 5, 2023 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. Link to comment Share on other sites More sharing options...
Alex Aydell Posted December 5, 2023 Author Share Posted December 5, 2023 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. Link to comment Share on other sites More sharing options...
Thorsten Vogt Posted December 5, 2023 Share Posted December 5, 2023 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now