Looking for a way to visualize this data

Elastic Stack Kibana
1

Hi there,

I have exported sleep data from my phone and am wondering if there is a way to visualize it with Kibana. It has multiple start and end times in every line.

Here's an example:

In bed start,In bed Finish,Minutes in bed,Minutes asleep,Time to fall sleep,Number of sleep periods,Sleep 1 start,Sleep 1 finish,Sleep 2 start,Sleep 2 finish,Sleep 3 start,Sleep 3 finish,Sleep 4 start,Sleep 4 finish,Sleep 5 start,Sleep 5 finish,Sleep 6 start,Sleep 6 finish,Sleep 7 start,Sleep 7 finish,Sleep 8 start,Sleep 8 finish,Sleep 9 start,Sleep 9 finish,Sleep 10 start,Sleep 10 finish,Sleep 11 start,Sleep 11 finish,Sleep 12 start,Sleep 12 finish,Sleep 13 start,Sleep 13 finish,Sleep 14 start,Sleep 14 finish,Sleep 15 start,Sleep 15 finish,Sleep 16 start,Sleep 16 finish,Sleep 17 start,Sleep 17 finish,Sleep 18 start,Sleep 18 finish,Sleep 19 start,Sleep 19 finish,Sleep 20 start,Sleep 20 finish,Sleep 21 start,Sleep 21 finish,Sleep 22 start,Sleep 22 finish,Sleep 23 start,Sleep 23 finish,Sleep 24 start,Sleep 24 finish
25-Apr-2018 01:52,25-Apr-2018 06:36,284.983333333333,259.916666666667,5.0,5,25-Apr-2018 01:57,25-Apr-2018 03:38,25-Apr-2018 03:56,25-Apr-2018 05:16,25-Apr-2018 05:17,25-Apr-2018 06:20,25-Apr-2018 06:21,25-Apr-2018 06:31,25-Apr-2018 06:32,25-Apr-2018 06:33
25-Apr-2018 22:29,26-Apr-2018 06:28,479.983333333333,472.783333333333,6.0,13,25-Apr-2018 22:35,25-Apr-2018 23:34,25-Apr-2018 23:35,25-Apr-2018 23:47,25-Apr-2018 23:48,26-Apr-2018 01:03,26-Apr-2018 01:04,26-Apr-2018 01:21,26-Apr-2018 01:22,26-Apr-2018 03:03,26-Apr-2018 03:04,26-Apr-2018 03:17,26-Apr-2018 03:18,26-Apr-2018 03:49,26-Apr-2018 03:50,26-Apr-2018 03:58,26-Apr-2018 03:59,26-Apr-2018 04:07,26-Apr-2018 04:08,26-Apr-2018 04:28,26-Apr-2018 04:29,26-Apr-2018 05:39,26-Apr-2018 05:40,26-Apr-2018 05:58,26-Apr-2018 05:59,26-Apr-2018 06:27
26-Apr-2018 23:02,27-Apr-2018 04:04,302.983333333333,284.783333333333,17.0,13,26-Apr-2018 23:19,26-Apr-2018 23:59,27-Apr-2018 00:01,27-Apr-2018 00:13,27-Apr-2018 00:14,27-Apr-2018 00:57,27-Apr-2018 00:58,27-Apr-2018 01:18,27-Apr-2018 01:19,27-Apr-2018 01:28,27-Apr-2018 01:29,27-Apr-2018 01:38,27-Apr-2018 01:39,27-Apr-2018 01:59,27-Apr-2018 02:00,27-Apr-2018 02:22,27-Apr-2018 02:23,27-Apr-2018 02:57,27-Apr-2018 02:58,27-Apr-2018 03:21,27-Apr-2018 03:22,27-Apr-2018 03:32,27-Apr-2018 03:33,27-Apr-2018 03:53,27-Apr-2018 03:54,27-Apr-2018 04:04
28-Apr-2018 01:02,28-Apr-2018 07:10,368.983333333333,362.766666666667,3.0,14,28-Apr-2018 01:05,28-Apr-2018 01:13,28-Apr-2018 01:15,28-Apr-2018 01:24,28-Apr-2018 01:25,28-Apr-2018 01:44,28-Apr-2018 01:45,28-Apr-2018 02:01,28-Apr-2018 02:02,28-Apr-2018 02:44,28-Apr-2018 02:45,28-Apr-2018 02:54,28-Apr-2018 02:55,28-Apr-2018 03:37,28-Apr-2018 03:38,28-Apr-2018 03:47,28-Apr-2018 03:48,28-Apr-2018 04:04,28-Apr-2018 04:05,28-Apr-2018 04:14,28-Apr-2018 04:15,28-Apr-2018 05:06,28-Apr-2018 05:07,28-Apr-2018 06:11,28-Apr-2018 06:12,28-Apr-2018 06:48,28-Apr-2018 06:49,28-Apr-2018 07:08
29-Apr-2018 01:35,29-Apr-2018 07:13,338.983333333333,322.916666666667,13.0,5,29-Apr-2018 01:48,29-Apr-2018 03:33,29-Apr-2018 03:35,29-Apr-2018 04:03,29-Apr-2018 04:04,29-Apr-2018 06:24,29-Apr-2018 06:25,29-Apr-2018 06:57,29-Apr-2018 06:58,29-Apr-2018 07:11
01-May-2018 00:05,01-May-2018 08:29,504.983333333333,427.733333333333,11.0,16,01-May-2018 00:16,01-May-2018 00:26,01-May-2018 00:28,01-May-2018 00:45,01-May-2018 00:46,01-May-2018 00:55,01-May-2018 00:56,01-May-2018 01:06,01-May-2018 01:07,01-May-2018 01:28,01-May-2018 01:29,01-May-2018 01:55,01-May-2018 01:56,01-May-2018 02:11,01-May-2018 02:12,01-May-2018 02:39,01-May-2018 02:40,01-May-2018 03:11,01-May-2018 03:12,01-May-2018 03:25,01-May-2018 03:26,01-May-2018 04:40,01-May-2018 04:41,01-May-2018 05:02,01-May-2018 05:03,01-May-2018 05:55,01-May-2018 05:56,01-May-2018 06:15,01-May-2018 06:16,01-May-2018 06:39,01-May-2018 06:40,01-May-2018 07:24
02-May-2018 00:03,02-May-2018 04:40,277.983333333333,226.916666666667,3.0,5,02-May-2018 00:06,02-May-2018 02:04,02-May-2018 02:06,02-May-2018 02:20,02-May-2018 02:21,02-May-2018 03:25,02-May-2018 03:26,02-May-2018 03:38,02-May-2018 03:39,02-May-2018 03:53
02-May-2018 20:35,03-May-2018 06:23,588.983333333333,545.7,13.0,18,02-May-2018 20:48,02-May-2018 21:00,02-May-2018 21:01,02-May-2018 21:17,02-May-2018 21:18,02-May-2018 21:50,02-May-2018 22:15,02-May-2018 23:22,02-May-2018 23:23,02-May-2018 23:37,02-May-2018 23:38,03-May-2018 00:56,03-May-2018 00:57,03-May-2018 01:07,03-May-2018 01:08,03-May-2018 02:14,03-May-2018 02:15,03-May-2018 02:23,03-May-2018 02:24,03-May-2018 02:39,03-May-2018 02:40,03-May-2018 03:14,03-May-2018 03:15,03-May-2018 03:44,03-May-2018 03:45,03-May-2018 04:28,03-May-2018 04:29,03-May-2018 05:03,03-May-2018 05:04,03-May-2018 05:31,03-May-2018 05:32,03-May-2018 06:02,03-May-2018 06:03,03-May-2018 06:14,03-May-2018 06:15,03-May-2018 06:17

The most interesting question is how to visualize the sleep start - sleep finish periods.
Looking forward to your ideas!

2

Hi @andre22 ,

one very simple example would be just using a date histogram chart with daily intervals and just presenting the relevant data as metrics (eg Average of Time to fall sleep etc).

3

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