Is it possible to plot a heat map with time range as input data?

[mmk1995 (MatthewMak)]

Hello all,

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?

Thank you.

[Nathan_Reese]

Kibana can not visualize a duration, so there is no way to visualize the time period while users are logged in.

You can create a heat map for the on_time event to see when users log in. You could alsocreate a heat map for the off_time event to see when users log off.