Idea ID 2867227
The COSO raw data tables have time indicated with an integer field in Unix epoch time only. Aggregated tables, such as *_1h and *_1d, have both an epoch field and a timestamp field.
I am attempting to create reports and dashboards with Power BI but not having a timestamp field in the raw tables is proving challenging. I can transform each epoch field to a time field with a calculation but that limits functionality like the ability to use direct queries. Actual datetime/timestamp fields are handled natively and requires no calculations. I imagine this is similar in other BI tools.
Benefits / Value:
Having a datetime/timestamp field for the raw metrics will make them easier to use with BI tools.
There are a dozen different ways to achieve this very easily.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.