We are using Kibana to display the evolution of the projects. A project in our case is a set of requirements with different States for e.g (In preparation, Approved, Implemented).
This image show an example:
The problem is, on 20.07.2018, we are storing the objects with their corresponding states, so total object is 7
But on 21.07.2018, the first object's(o1) state changed from implemented to approved.
And whe have liked Kibana/Timelion to display in area trend charts the correct counts for each day for the three States.
I see here two possibilities:
- Re-importing the data every day (Not only the one which change) -> Data grow to fast.
- Maintaining a second index which store a count for each given state on a daily based -> User can only see the count and not the objects).
Is there another elegant way to solve that? Any Idea ?
Thanks in advance.