How to create a timeline

Hello Community,
I have a question regarding updating data. I wrote a script in Python to create a random csv file. The CSV file contains: _id, name, status and date.
Now here is my Question: If I have a lane e.g.
id; name; status; date
1; Project A; failed; 2022-02-10

now the project is in the next step and "failed" changes to "passed"

1;Project A; passed; 2022-02-11

How can I index the data to create a timeline to see how long it takes to change a "status"(solve a problem ticket)

Here is my mapping:

       Settings = {
            "settings": {
                "number_of_shards": 1,
                "number_of_replicas": 2
            },
            "mappings": {
                "_id": {
                    "type": "long"
                },
                "properties": {
                    "name": {
                        "type": "text"
                    },
                    "status": {
                        "type": "text"
                    },
                    "time": {
                        "type": "date"
                    }
                }
            }
        }

Thx

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