Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I have a table with machine temperatures and one with production start/end times for products
Temperature:
Timestamp | Machine | Temperature |
2020-07-01 12:32 | 1 | 21.1 |
2020-07-01 13:35 | 1 | 21.6 |
2020-07-01 13:40 | 1 | 22.2 |
2020-07-01 14:55 | 1 | 21.6 |
production times
Machine | Product | Starttime | Endtime |
1 | A | 2020-07-01 12:41 | 2020-07-01 13:30 |
3 | B | 2020-07-01 12:35 | 2020-07-01 14:21 |
2 | C | 2020-07-01 13:54 | 2020-07-02 01:54 |
1 | D | 2020-07-03 07:58 | 2020-07-03 09:28 |
I already have a temperature graph that will show me the range of a selected product from the production times table. However if I select a product where the production time do not have any temperature data nothing wil be shown. for example if I select the first row in the production table. I want to show a line in the visual anyway which should then go from starttime woth the latest temperature value before starttime to the endtime with earliest temperature value after endtime.
is that even possible?
Thanks
Hi @Kristianhk ,
Your description is not clear to me. Would you please show us the expected output? Then we will help you more correctly.
Thanks for your understanding and support.
Best Regards,
Dedmon Dai
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |