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

**URL:** <https://discuss.elastic.co/t/is-it-possible-to-plot-a-heat-map-with-time-range-as-input-data/197097>\
**Category:** Kibana\
**Created:** [August 28, 2019, 11:31am UTC](https://discuss.elastic.co/t/is-it-possible-to-plot-a-heat-map-with-time-range-as-input-data/197097 "2019-08-28T11:31:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mmk1995](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mmk1995](https://discuss.elastic.co/u/mmk1995)\
**Post date:** [August 28, 2019, 11:31am UTC](https://discuss.elastic.co/t/is-it-possible-to-plot-a-heat-map-with-time-range-as-input-data/197097/1 "2019-08-28T11:31:11Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [August 28, 2019, 2:20pm UTC](https://discuss.elastic.co/t/is-it-possible-to-plot-a-heat-map-with-time-range-as-input-data/197097/2 "2019-08-28T14:20:08Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 25, 2019, 2:20pm UTC](https://discuss.elastic.co/t/is-it-possible-to-plot-a-heat-map-with-time-range-as-input-data/197097/3 "2019-09-25T14:20:10Z")

</div>

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