I have data as below:
on_time,off_time,user,PC 2018-09-01 00:34:27.540,2018-09-01 03:40:34.870,xxxxxxx,NA016F 2018-09-01 02:55:55.710,2018-09-01 02:58:55.860,yyyyyyyy,NB106F 2018-09-01 03:44:24.460,2018-09-01 04:18:32.300,aaaaaaaa,NA076F 2018-09-01 04:19:33.440,2018-09-01 05:38:44.470,ttttttttt,NA031F 2018-09-01 04:45:26.150,2018-09-01 05:55:53.580,qqqqqqqq,NA046F 2018-09-01 06:18:43.460,2018-09-01 10:02:28.490,wwwwww,CC004D 2018-09-01 08:06:22.880,2018-09-01 13:54:01.040,eeeeeeee,NB083F 2018-09-01 08:07:24.530,2018-09-01 08:12:20.880,zzzzzzzzzz,NA091F 2018-09-01 08:14:11.630,2018-09-01 08:17:43.300,bbbbbbb,NA110F
of course there is lot more data in terms of month or year.
here is have on_time as logon time and off_time as logoff time of a computer.
I want to plot a heat map like this: with Y axis hour (0 - 24) or even 24hours x 60minutes and X axis weekday (Mon - Sun)
The time between logon and logoff time will lie on the heat map and the count will be the matrix.
The heat map will finally shows which period of time have the most people using PCs as deeper color indicates.
Is it possible for Kibana to plot such heat map?