Sum duration activties


(Tony) #1

Hi,

Is it possible to create a chart to track users activity (with entries elasticsearch, time filed AAAAMMJJ HH:MM:SS => filed 1 : begin connection, filed 2 : end connection) ?

Regards,

Tony


(Matt Bargar) #2

If I'm understanding your use case correctly, I think a scripted field would solve the problem.

You could create a scripted field called time_connected:

doc.['end_connection'].value - doc.['begin_connection'].value

And then you could visualize this field in the Visualize tab. If that's not what you're looking for, please provide more details on what you're trying to achieve.


(Tony) #3

Hi Matt,

Is it possible in the same graph, to have a sum of user by time slot.

For exemple elasticsearch entries :
Entry 1 :
LoginTime : 2015-12-31T20:58:00
LogoutTime : 2015-12-31T23:10:00
UserName : XX

Entry 2 :
LoginTime : 2015-12-31T20:58:00
LogoutTime : 2015-12-31T23:10:00
UserName : XX

Is it possible to generate a graph for a period, cutting by hour with sum of user during this time ?

[cid:image001.png@01D15ABA.176F6BD0]

Regards,

Tony

De : Matt Bargar [mailto:noreply@discuss.elastic.co]
Envoyé : vendredi 29 janvier 2016 15:59
À : JARRIAULT, Tony
Objet : [Kibana] Sum duration activties

[https://discourse-cdn-sjc1.com/elastic/user_avatar/discuss.elastic.co/bargs/45/5429_1.png]

Bargshttp://discuss.elastic.co/users/bargs Matt Bargarhttp://discuss.elastic.co/users/bargs
January 29

If I'm understanding your use case correctly, I think a scripted fieldhttps://www.elastic.co/guide/en/kibana/current/managing-fields.html#create-scripted-field would solve the problem.

You could create a scripted field called time_connected:

doc.['end_connection'].value - doc.['begin_connection'].value

And then you could visualize this field in the Visualize tab. If that's not what you're looking for, please provide more details on what you're trying to achieve.

To respond, reply to this email or visit the topichttp://discuss.elastic.co/t/sum-duration-activties/40294/2.


(Matt Bargar) #4

So want the number of unique users who have logged in each hour? Or you want the total number of times each user has logged in, per hour?


(Tony) #5

Hi Matt,
I want the number of unique user for each hour

regards,

[Prosodie-signature]http://www.prosodie.com/

Tony JARRIAULT – Responsable de groupe Mise en Service Technique
PROSODIE - Division Front Office Platform
Tél. : +33 (0)1.34.49.06.43(TOIP/Mobile)
Fax : +33 (0)1.34.49.06.79
tjarriault@prosodie.commailto:tjarriault@prosodie.com

8, rue Grange Dame Rose - 78457 Velizy-Villacoublay Cedex
P afin de contribuer au respect de l'environnement, merci de n'imprimer ce mail qu'en cas de nécessité

De : Matt Bargar [mailto:noreply@discuss.elastic.co]
Envoyé : vendredi 29 janvier 2016 17:56
À : JARRIAULT, Tony
Objet : [Kibana] Sum duration activties

[https://discourse-cdn-sjc1.com/elastic/user_avatar/discuss.elastic.co/bargs/45/5429_1.png]

Bargshttp://discuss.elastic.co/users/bargs Matt Bargarhttp://discuss.elastic.co/users/bargs
January 29

So want the number of unique users who have logged in each hour? Or you want the total number of times each user has logged in, per hour?

To respond, reply to this email or visit the topichttp://discuss.elastic.co/t/sum-duration-activties/40294/4.


(Matt Bargar) #6

That should be fairly easy to accomplish. You just need to create a date histogram with an hourly interval and a unique count aggregation on the UserName field as your metric. Something like this:


(system) #7