You can still get a "Silent Assassin" rank on a mission if you are spotted. To get a "Silent Assassin" rank, there has to be nothing in the aggression bar. You can make sure of this by only using chloroform on guards and eliminating the target with just one shot.