Hello,
I have two different lists that have a similar structure columnwise , like the following:
Date (D) | Machine (ID) | Time Spent (h)
--------------------------------------------
The Lists are connected by the Column Date in both directions enabling crossfiltering.
i am trying to create a Dashboard in form of a table where i can see the total time that was spend on one machine h1 and h2 and the added time from both tables h3.
----------| Day 1 | Day 2 | Day 3 | Day 4 | ......
Machine 1 h1|h2|h3
Machine 2
Machine 3
Machine 4
...
My Goal is, that only the task that was performed the same day on the same machine ist listed in the table.
Instead the total amount of all task of all machines from list 2 is listed in the table.
For example:
List 1:
Date (D) | Machine (ID) | Time Spent (h)
20.02.18 | M1 | 3h |
21.02.18 | M1 | 4h |
List 2:
Date (D) | Machine (ID) | Time Spent (h)
20.02.18 | M1 | 7h |
Result:
----------| 20.02.2018 | 21.02.2018 | Day 3 | Day 4 | ......
Machine 1 3h | 7h | 4h
Machine 2 7h
Machine 3 7h
Machine 4 7h
...
I dont know how to enable, that it will also filter for the machine ID and not only for the date.
Any help would be appreciated.
Thank you a lot.
