I am trying to display two lines on the same chart using the secondary Y-axis. However, when I add the second line to the chart (on the secondary axis), the values are getting aggregated, which is not what I want. Both lines are plotted against the same Y-axis.
How can I plot these two metrics on the same chart while ensuring that the secondary axis values are displayed correctly (without aggregation)?
Here are the screenshots of the current setup and the issue I’m trying to solve:
Any guidance on how to fix this would be appreciated!
data sample
| %GT Histogram Arrival Delay | rounded_scheduled_TAT_min |
| 0.38% | 30 |
| 11.49% | 40 |
| 10.19% | 50 |
| 17.55% | 60 |
| 8.76% | 70 |
| 4.88% | 80 |
| 9.88% | 90 |
| 4.18% | 100 |
| 4.05% | 110 |
| 3.62% | 120 |
| 3.20% | 130 |
| 2.13% | 140 |
| 1.68% | 150 |
| 1.43% | 160 |
| 1.49% | 170 |
| 1.79% | 180 |
| 1.55% | 190 |
| 1.11% | 200 |
| 0.93% | 210 |
| 0.97% | 220 |
| 0.97% | 230 |
| 1.51% | 240 |
| 1.28% | 250 |
| 1.32% | 260 |
| 1.03% | 270 |
| 1.42% | 280 |
| 0.78% | 290 |
| 0.41% | 300 |
| %GT Histogram Arrival Delay | rounded_actual_TAT_min |
| 0.98% | |
| 0.70% | 30 |
| 7.17% | 40 |
| 16.61% | 50 |
| 13.50% | 60 |
| 9.54% | 70 |
| 7.91% | 80 |
| 6.20% | 90 |
| 5.45% | 100 |
| 4.04% | 110 |
| 3.64% | 120 |
| 2.61% | 130 |
| 2.36% | 140 |
| 1.79% | 150 |
| 1.58% | 160 |
| 1.61% | 170 |
| 1.61% | 180 |
| 1.38% | 190 |
| 1.09% | 200 |
| 1.13% | 210 |
| 1.24% | 220 |
| 1.14% | 230 |
| 1.15% | 240 |
| 1.21% | 250 |
| 1.01% | 260 |
| 1.19% | 270 |
| 1.10% | 280 |
| 0.91% | 290 |
| 0.15% | 300 |
Sure HYG a sample data and the both curves have the same column whish is the %GT Histogram Arrival Delay
and the other 2 columns are
I am attempting to visualize the difference between the scheduled and actual values.
