Forum Discussion
Connecting time slots with time stamp data
Hi!
I'm new to the forum, and I'd like to get any help regarding this issue. I have two datasets connected by time. One of them is a time slot with a status for each of them:
Category | Event | Initial time | End time | Duration |
| Condition | A | 11/11/2020 00:00:00 | 11/11/2020 01:49:21 | 01:49:21 |
| Condition | B | 11/11/2020 01:49:21 | 11/11/2020 01:51:29 | 00:02:08 |
| Condition | A | 11/11/2020 01:51:29 | 11/11/2020 02:14:41 | 00:23:12 |
| Condition | B | 11/11/2020 02:14:41 | 11/11/2020 02:14:56 | 00:00:15 |
The second table is a timestamp typical table for time-based data:
| Date | Data A | Data B |
| 11/11/2020 0:00:00 | 25 | 35 |
| 11/11/2020 0:10:00 | 45 | 20 |
| 11/11/2020 0:20:00 | 20 | 25 |
| 11/11/2020 0:30:00 | 32 | 30 |
| 11/11/2020 0:40:00 | 12 | 45 |
| 11/11/2020 0:50:00 | 45 | 210 |
| 11/11/2020 1:00:00 | 50 | 220 |
| 11/11/2020 1:10:00 | 241 | 235 |
How I can connect each row of the second table with the appropriate data from the 1st table?
Any help would be appreciated. Thanks!
gmiro , You can get data from first table into second table like
maxx(filter(first, second[Date]>= first[Initial time] && second[Date]<= first[End time]), first[Duration])
also refer the way to get data from one table to another - https://www.youtube.com/watch?v=czNHt7UXIe8
1 Reply
- amitchandak
Super User
gmiro , You can get data from first table into second table like
maxx(filter(first, second[Date]>= first[Initial time] && second[Date]<= first[End time]), first[Duration])
also refer the way to get data from one table to another - https://www.youtube.com/watch?v=czNHt7UXIe8