Displaying time lag data as an average over time using TSVB

Elastic Stack Kibana
1

Hi,

I would like some assistance please.

I'm using Amazon OpenSearch Service (successor to Amazon Elasticsearch Service).

Currently I have set of documents in my index that have following date/time fields

  • "CreatedDateTime"
  • "ProcessedDateTime"

The CreatedDateTime in the represents when the document was created.
The ProcessedDateTime represents when my application had successfully processed the document.

For each of the documents I would like to calculate and then display the difference as a single unit / display that as an average over a given period. Essentially I would to display the "lag" over a given period.

I've setup a "script field" on my index pattern. I used this in my script:

doc['CreatedDateTime'].date.millis - doc['ProcessedDateTime'].date.millis

I then went to create a TSVB visualisation but I don't know how to use the script field within here.

How could I use TSVB to display what I'm trying to do?
Is TSVB the correct visualisation to use?

2

Unfortunately we are not able to help on this as opensearch is an aws run fork of Elasticsearch and Kibana.

1 Like
3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.