How many comics need to be sold for a story to be considered a success?

None. OP, you're a success just for trying. Publish your dream, sales won't add to or take away from that.