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