Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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 🙂
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |