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
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.
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://sea2.discourse-cdn.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.
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?
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://sea2.discourse-cdn.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.
