I think it should doable in Tableau, however, I have a question about what if failed to completed on time, what the range should be? Null value or something else?
Thanks ZZ, the range will go into -minus figures, roughly around -50
In this case, probably you could create a flag such as [Flag]
if range >= 0 then
"Failed On Time"
And drag this calculation field to color or detail so that you can see both charts in the same worksheet.