cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pagaczpagacz Frequent Visitor
Frequent Visitor

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

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:0062,06255358,9375
11.10.2019 08:44:0162,06255358,9375
11.10.2019 08:44:0262,06255358,9375
11.10.2019 08:44:0362,06255358,9375
11.10.2019 08:44:0462,06255358,9375
11.10.2019 08:44:0562,06255358,9375
11.10.2019 08:44:0662,062552,9376220758,9375
11.10.2019 08:44:0762,062552,937558,9375
11.10.2019 08:44:0862,062552,937558,9375
11.10.2019 08:44:0962,062552,937558,9375
11.10.2019 08:44:1062,062552,937558,9375
11.10.2019 08:44:1162,062552,937558,9375
11.10.2019 08:44:1262,062552,937558,9375
11.10.2019 08:44:1362,062552,937558,9375
11.10.2019 08:44:1462,062552,937558,9375
11.10.2019 08:44:1562,062552,937558,9375
11.10.2019 08:44:1662,062552,937558,9375
11.10.2019 08:44:1762,062552,937558,9375
11.10.2019 08:44:1862,062552,937558,9375
11.10.2019 08:44:1962,062552,937558,9375
11.10.2019 08:44:2062,062552,882812558,9375
11.10.2019 08:44:2162,062552,8750076358,9375
11.10.2019 08:44:2262,062552,87558,9375
11.10.2019 08:44:2362,062552,87558,9375
11.10.2019 08:44:2462,062552,87558,9375
11.10.2019 08:44:2562,062552,87558,9375
11.10.2019 08:44:2662,062552,87558,9375
11.10.2019 08:44:2762,062552,87558,9375
11.10.2019 08:44:2862,062552,87558,9375
11.10.2019 08:44:2962,062552,87558,9375
11.10.2019 08:44:3062,062552,87558,99993896
11.10.2019 08:44:3162,062552,87559
11.10.2019 08:44:3262,062552,87559
11.10.2019 08:44:3362,062552,87559
11.10.2019 08:44:3462,062552,87559
11.10.2019 08:44:3562,062552,8126220759
11.10.2019 08:44:3662,062552,812559
11.10.2019 08:44:3762,062552,812559
11.10.2019 08:44:3862,062552,812559
11.10.2019 08:44:3962,062552,812559
11.10.2019 08:44:4062,062552,812559
11.10.2019 08:44:4162,062552,812559
11.10.2019 08:44:4262,062552,812559
11.10.2019 08:44:4362,062552,812559
11.10.2019 08:44:4462,062552,812559
11.10.2019 08:44:4562,062552,812559
11.10.2019 08:44:4662,062552,812559
11.10.2019 08:44:4762,062552,812559
11.10.2019 08:44:4862,062552,812559
11.10.2019 08:44:4962,062552,812559
11.10.2019 08:44:5062,062552,812559
11.10.2019 08:44:5562,062552,812559
11.10.2019 08:44:5662,062552,812559,06054688
11.10.2019 08:44:5762,062552,812559,0625
11.10.2019 08:44:5862,062552,812559,0625
11.10.2019 08:44:5962,062552,812559,00006104

 

1 ACCEPTED SOLUTION

Accepted Solutions
pagaczpagacz Frequent Visitor
Frequent Visitor

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

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 🙂 

View solution in original post

1 REPLY 1
pagaczpagacz Frequent Visitor
Frequent Visitor

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

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 🙂 

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 184 members 1,712 guests
Please welcome our newest community members: