I'm just spending my first week or so with Kibana and trying to build dashboards to visualize performance indicators that my team is interested in tracking. At the moment, what I'd like to make a line chart time series tracking the number of first-time deposits made by users each week.
I have an index called "event-deposit-finished" that tracks completed deposit events as they occur, but for the sake of my testing right now I'm just working with historical data.
If I were querying this in SQL, I'd probably approach this in roughly the following manner:
- Get a unique set of all users who have a completed deposit (event-deposit-finished index)
- For each unique user, find their first finished deposit
- Count the number of first-time deposits in each week
- Plot the resultant series of values
My event-deposit-finished index includes a date field as well as the user ID that made the deposit.
Moving on from here, I'm also interested in a chart that can track the time between a user registering and their first completed deposit, as we'd like to minimize this metric. I have another index "event-user-registered" that I can get the date and user ID of user registrations from. I gather this might be something I have to use timelion for, but I'm only just beginning to scratch the surface of what timelion can do.