I'm currently trying to solve the following problem:
We have users that are active from the date when they start a certain action to the date when they complete it. We need to display a graph showing the number of active users through time (a time series graph for day/month is preferred).
A user is active from the time when we receive a log of his start action to the date when we receive a log that he completed the action.
- Start log (contains status = "Activated" and start_date)
- End log (contains status = "Completed" and completed_date)
For each time point, the graph would need to take into consideration all documents up to that date and then iterate further in time taking into consideration new events that were added.
I managed to create a custom aggregation that works for a specific date and can show me all the active users on that specific date (using Vega and only showing a number). But I am wondering how to plot these values in a time graph. It would be pretty easy to use a script that daily/monthly creates a new document that summarizes the situation at that point in time but I am wondering if there is a Kibana solution that could do this task. From my current knowledge transforms would only allow me to create a summary document from today forward, and not for dates in the past.
Thank you for your help.