hello i am using latest version of opensearch 2.16
i have two different data in my metrics index (ss4o_metrics-otel-2024.09.10) data-1
name:kube_node_cpu_usage and data-2 name:kube_node_allocatable_cpu
i want to divided this value
{
"_index": "ss4o_metrics-otel-2024.09.10",
"_id": "5MGe2pEB9SGP9NxGt84p",
"_version": 1,
"_score": null,
"_source": {
"unit": "{cpu}",
"exemplars": [],
"kind": "GAUGE",
"name": "kube_node_allocatable_cpu",
"flags": 0,
"description": "Amount of cpu allocatable on the node",
"startTime": "1970-01-01T00:00:00Z",
"attributes": {
"instrumentationScope.name": "github.com/open-telemetry/opentelemetry-collector-contrib/receiver/k8sclusterreceiver",
"metric.attributes.attributenaman": 123,
"instrumentationScope.version": "0.108.1",
"resource": {
"attributes": {
"kts_node_name": "minikube",
"kts_node_uid": "3dc0cb11-7e7b-45c9-9c1a-c26b91e4f7ce"
}
}
},
"time": "2024-09-10T06:28:35.344719812Z",
"serviceName": null,
"value": 8,
"schemaUrl": "https://opentelemetry.io/schemas/1.18.0"
},
"fields": {
"startTime": [
"1970-01-01T00:00:00.000Z"
],
"time": [
"2024-09-10T06:28:35.344Z"
]
},
"highlight": {
"name": [
"@opensearch-dashboards-highlighted-field@kube_node_allocatable_cpu@/opensearch-dashboards-highlighted-field@"
]
},
"sort": [
1725949715344
]
}
data-2 below
{
"_index": "ss4o_metrics-otel-2024.09.10",
"_id": "Usmo2pEB9SGP9NxGjkP4",
"_version": 1,
"_score": null,
"_source": {
"unit": "{cpu}",
"exemplars": [],
"kind": "GAUGE",
"name": "kube_node_cpu_usage",
"flags": 0,
"description": "Total CPU usage (sum of all cores per second) averaged over the sample window",
"startTime": "2024-09-10T04:42:03Z",
"attributes": {
"instrumentationScope.name": "github.com/open-telemetry/opentelemetry-collector-contrib/receiver/kubeletstatsreceiver",
"metric.attributes.attributenaman": 123,
"instrumentationScope.version": "0.108.1",
"resource": {
"attributes": {
"kts_node_name": "minikube"
}
}
},
"time": "2024-09-10T06:39:25.402917953Z",
"serviceName": null,
"value": 0.850103888,
"schemaUrl": ""
},
"fields": {
"startTime": [
"2024-09-10T04:42:03.000Z"
],
"time": [
"2024-09-10T06:39:25.402Z"
]
},
"highlight": {
"name": [
"@opensearch-dashboards-highlighted-field@kube_node_cpu_usage@/opensearch-dashboards-highlighted-field@"
]
},
"sort": [
1725950365402
]
}