Hey guys, I need some help with a Kibana visualization i'm putting together. I would like to perform an aggregation and comparison in a very specific way and I'm not sure if its possible with Kibana or not. Any help would be appreciated.
So on to the problem.
Lets say I have an index called "user-logged-in-time" with documents like this:
{
"user_id" : 82342,
"time_spent_in_application" : 112,
"date" : "2017-01-18"
}
Lets say I have thousands of users and my application has been live for 10 years resulting in tonnes of data points like the one above.
I would now like to create a visualisation which tells me, which specific users have increased their time spent in the application the most over each year.
In my head, the way this would work is, I would aggregate the total time spent per year per user. Then I would calculate the percentage increases between one year and the next(per user), and then somehow plot the users with their respective percentage increases, ordered by percentage increase.
I hope I made sense.
If percentages aren't available in Kibana, even deltas would work i think.
Is this something thats possible with Kibana 4.x or even 5? is TimeLion able to do this?
Best regards,
am87