UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.

Add timestamp Field To Raw Data Tables in COSO Schemas

Idea ID 2867227

Add timestamp Field To Raw Data Tables in COSO Schemas

Brief Description:

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.

timestamp_utc_s (integer)
https://docs.microfocus.com/itom/Containerized_Operations_Bridge:2020.10/AgentCPU

timestamp (timestamp_tz)
https://docs.microfocus.com/itom/Containerized_Operations_Bridge:2020.10/AgentCPUHourly

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.

Design details:

There are a dozen different ways to achieve this very easily.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.