How can I have a leaderboard where, for example, one category is ranked by in game time by default, and another category is ranked by real time by default. It seems like you can only set a default ranking method for the whole leaderboard.

There's no simple way to do this, but you could set real time as the default and only submit in-game time and not real time values in the category you want organized by in-game time.