If they are ineffective, I'd not expect any attacks to be stopped at the checkpoint due to its ineffectiveness.
If they are effective, I'd not expect any attacks to be stopped at the checkpoint because the attackers know about the checkpoint. If they don't know how to get past it, they will not start the attack.
We do know that before checkpoints where introduced in the early '70s there were a lot more hijackings. In 1969 there were over two dozen hijackings to Cuba, for example. Airline hijackings went way down after checkpoints were introduced and made it so you had to have a more sophisticated plan to get a gun onto a plane than simply tossing it into your carryon bag.
My point is that "attacks stopped at checkpoint" is not a useful measure, because it has little if any connection to the effectiveness or lack thereof of the checkpoint.