Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I want to create a custom visual showing the Relationship betwwen arrival and departure flights with arrow line towards departure flight. The thickness of line should be based on number of passengers on departure flight and the color of line should be green( surplus time >=15), yellow between <15 and >=10, Red <10). Sample data is given below and visual is also shown below. Please, can anyone help me out in this.
Arrival Flight | Departure Flight | Number of passengers on Departue flight | Surplus Time (minutes) |
A1 | D1 | 5 | 19 |
A1 | D2 | 8 | 25 |
A1 | D6 | 8 | 18 |
A1 | D9 | 4 | 20 |
A1 | D10 | 6 | 27 |
A1 | D8 | 2 | 16 |
A1 | D5 | 7 | 5 |
A2 | D1 | 4 | -6 |
A2 | D4 | 8 | 8 |
A2 | D4 | 6 | 21 |
A2 | D3 | 6 | 21 |
A3 | D6 | 5 | 20 |
A4 | D5 | 5 | 2 |
A4 | D8 | 9 | 10 |
A5 | D6 | 12 | 12 |
A6 | D5 | 10 | -10 |
A7 | D9 | 6 | 12 |
A7 | D8 | 1 | 15 |
A7 | D3 | 8 | 16 |
A8 | D1 | 3 | 17 |
A9 | D2 | 2 | 16 |
A10 | D3 | 2 | 18 |
A10 | D9 | 7 | 22 |