Representation of Flow sequences in a Pie Chart


(Hicham Mouddi) #1

Hello,

I am new in using Kibana, and I would like to visualise a temporal sequence of actions in a PieChart.

Context : :
Each time a user receive a notification on his smartphone, I collect the log (user_id, timestamp, name of the notification), and I want to know the temporal sequence of received notifications aggregated per users.

EX : The first level of the pie chart shows slices that represents the notification which has been sent first to the user . Each size of the slice represents the percentage of unique users who received that notification first.
Then the 2nd level of the pie chart represents the percentage of users who received the notification after the first one ....

See image below :

Level 1 : 25% of the users have received in the first instance the Notification A
25% of the users have received in the first instance the Notification B
25% of the users have received in the first instance the Notification C
25% of the users have received in the first instance the Notification D

Level 2 :
For those who received the notification A firstly :
- 50 % received the notification B after
- 50 % received the notification C after

Etc ....

If someone knows how to represent it on Kibana, I would be very grateful.

Thanks in advance,


(Joe Fleming) #2

I'm not sure this is possible in Kibana, but let me ask, how are you storing this data? Are these all single documents in Elasticsearch, with just a user, notification type, and time? If so, then it's definitely not going to be possible.

I think you could probably get the data you're looking for using pipeline aggregations, but Kibana doesn't have support for those at the moment.

For this to work in Kibana, you'd need to keep track of the events in a single record, in separate columns. For example, something like this:

time | user_id | notif_1 | notif_2 | notif_3 | notif_4
xxx  |  1      | A       | B       | C       | D
xxx  |  2      | C       | B       |         |  
xxx  |  5      | D       | A       | C       | 
xxx  |  1      | E       | B       | D       | A
xxx  |  8      | B       |         |         |  

Not ideal, since you'll need to write custom application logic to manage this and store it correctly. But without that, you can't add different buckets to your aggregations and get those different levels on the pie chart.


(Hicham Mouddi) #3

Dear Fleming,

Thanks for your answer and the details given. Actually, the datas are stored as follow :

Time, UserId, Notification
xxx, User1, Notification_welcome
xxx, User1, Notification_lunch
xxx, User2, Notification_welcome
xxx, User2, Notification_game
xxx, User2, Notification_lunch

If I follow my logic, I should order by time the sequence of notifications received and aggregate by user.
It should give us something like that :

UserId, Notification1, Notification2, Notification3, ....
User1, Notification_welcome, Notification_lunch
User2, Notification_welcome, Notification_game, Notification_lunch

But I don't know, how to implement it with the dev tools.

This is for datas transformation. For the Vizualisation, I found some kibana plugins that could be suitable such as : Sankey Plugin or Sunburst plugin (that does what I want to do with the piechart).

Thanks


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.