Aggregation by hour:minute for hour:minute:second stamp

[pagaczpagacz]

Hello there,

I have question about aggregation by time stamp.

My time stamp is day:month:year hour:minute:second and I need to show my data after aggregation to day:month:year hour:minute.

Have you any ideas how should I do that?

Sometimes there is only one "value" per minute and next following 59 seconds are 'null'.

Thanks in advance 🙂

This is dataset for one minute:

11.10.2019 08:44:00	62,0625	53	58,9375
11.10.2019 08:44:01	62,0625	53	58,9375
11.10.2019 08:44:02	62,0625	53	58,9375
11.10.2019 08:44:03	62,0625	53	58,9375
11.10.2019 08:44:04	62,0625	53	58,9375
11.10.2019 08:44:05	62,0625	53	58,9375
11.10.2019 08:44:06	62,0625	52,93762207	58,9375
11.10.2019 08:44:07	62,0625	52,9375	58,9375
11.10.2019 08:44:08	62,0625	52,9375	58,9375
11.10.2019 08:44:09	62,0625	52,9375	58,9375
11.10.2019 08:44:10	62,0625	52,9375	58,9375
11.10.2019 08:44:11	62,0625	52,9375	58,9375
11.10.2019 08:44:12	62,0625	52,9375	58,9375
11.10.2019 08:44:13	62,0625	52,9375	58,9375
11.10.2019 08:44:14	62,0625	52,9375	58,9375
11.10.2019 08:44:15	62,0625	52,9375	58,9375
11.10.2019 08:44:16	62,0625	52,9375	58,9375
11.10.2019 08:44:17	62,0625	52,9375	58,9375
11.10.2019 08:44:18	62,0625	52,9375	58,9375
11.10.2019 08:44:19	62,0625	52,9375	58,9375
11.10.2019 08:44:20	62,0625	52,8828125	58,9375
11.10.2019 08:44:21	62,0625	52,87500763	58,9375
11.10.2019 08:44:22	62,0625	52,875	58,9375
11.10.2019 08:44:23	62,0625	52,875	58,9375
11.10.2019 08:44:24	62,0625	52,875	58,9375
11.10.2019 08:44:25	62,0625	52,875	58,9375
11.10.2019 08:44:26	62,0625	52,875	58,9375
11.10.2019 08:44:27	62,0625	52,875	58,9375
11.10.2019 08:44:28	62,0625	52,875	58,9375
11.10.2019 08:44:29	62,0625	52,875	58,9375
11.10.2019 08:44:30	62,0625	52,875	58,99993896
11.10.2019 08:44:31	62,0625	52,875	59
11.10.2019 08:44:32	62,0625	52,875	59
11.10.2019 08:44:33	62,0625	52,875	59
11.10.2019 08:44:34	62,0625	52,875	59
11.10.2019 08:44:35	62,0625	52,81262207	59
11.10.2019 08:44:36	62,0625	52,8125	59
11.10.2019 08:44:37	62,0625	52,8125	59
11.10.2019 08:44:38	62,0625	52,8125	59
11.10.2019 08:44:39	62,0625	52,8125	59
11.10.2019 08:44:40	62,0625	52,8125	59
11.10.2019 08:44:41	62,0625	52,8125	59
11.10.2019 08:44:42	62,0625	52,8125	59
11.10.2019 08:44:43	62,0625	52,8125	59
11.10.2019 08:44:44	62,0625	52,8125	59
11.10.2019 08:44:45	62,0625	52,8125	59
11.10.2019 08:44:46	62,0625	52,8125	59
11.10.2019 08:44:47	62,0625	52,8125	59
11.10.2019 08:44:48	62,0625	52,8125	59
11.10.2019 08:44:49	62,0625	52,8125	59
11.10.2019 08:44:50	62,0625	52,8125	59
11.10.2019 08:44:55	62,0625	52,8125	59
11.10.2019 08:44:56	62,0625	52,8125	59,06054688
11.10.2019 08:44:57	62,0625	52,8125	59,0625
11.10.2019 08:44:58	62,0625	52,8125	59,0625
11.10.2019 08:44:59	62,0625	52,8125	59,00006104

[pagaczpagacz · Accepted solution]

Ok, I think I have my answer.

I just split my date stamp by 3 signs from right and I got column like day:month:year hour:minute:00 and aggregation made automatically at visualisation level (only thing is to change from sum to avg).

So simple 🙂