I looked at the any% and noticed that there were a bunch of missing rankings for higher rankings but didn't see any reason why this occured. If anyone could explain this that would be great.

The missing rankings are due to there being a split between amiibo and no amiibo runs, if you want to see the rankings for no amiibo, you can use the filters.