Versions (relevant - OpenSearch/Dashboard/Server OS/Browser): 2.11
Describe the issue:
I am trying to build visualizations that will correlate records based on a particular field which is designated as keyword. Sample documents are below, but what I am wanting to do is to be able to get a duration for each jobId. What I am trying to do is to take the timestamp from the document where the status = Completed and subtract the timestamp from the document where the status = Started . I have been able to make some useful visualizations using enhanced tables and by splitting it up by jobId I can get pretty close to what is needed, minus the duration component.
99b78e58-b199-4748-bf63-50b9f9c9450d: Job ID
Display Name | Time | Status | Jobs
myCodRefresh | Oct 18, 2024 @ 15:53:09.000 | Started | 1
myCodRefresh | Oct 18, 2024 @ 16:20:52.000 |Completed | 1
Configuration:
Relevant Logs or Screenshots:
{
“timestamp”: “1729398469000”,
“jobId”: “bb4b7cb4-049e-42b9-a9d5-3ce64888cc56”,
“refreshType”: “Code-OnPrem”,
“displayName”: “myCodRefresh”,
“status”: “Completed”
}
{
“timestamp”: “1729377876000”,
“jobId”: “bb4b7cb4-049e-42b9-a9d5-3ce64888cc56”,
“refreshType”: “Code-OnPrem”,
“displayName”: “myCodRefresh”,
“status”: “Started”
}