I'm trying to draw a stacked bar graph with two different measures, one lying on top of another (On-Time Flights and Delayed Flights). The solutions I found draw the sum of Delayed-Flights on top of On-Time Flights and labels them as whole decimal value. However, I also want the label to have percentage of On-Time Flights over total, which is On-Time Flights + Delayed Flights, but when I used the Quick Table Calculation > Percent of Total, the percentage of the two values doesn't add up to 100%. And I can't subdivide the total with dimension because the original data doesn't have that. Any help would be greatly appreciated
Attached here is the file.
Thank you for your time.