I haven't seen the movie yet, but I know this much: you can't cheat.
If you do, and you keep some fundamental fact hidden until the last minute, or if you use some kind of magic, or if the murderer was a complete outsider, or if the victim died by accident and nobody's guilty, or, God forbid! if it turns out the victim isn't actually dead, or it was all a dream... then the audience gets angry. Sometimes very angry. That may be what happened here.
To paraphrase Walter Sobchak, this isn't 'Nam. There are rules to writing detective stories.