Grouping Results in an Azure App Insights Analytics Query
Just to answer my own question: all the results were actually there it's just Analytics itself (helpfully?) only selects the first four unless you specify otherwise in a drop down menu at the top of the chart.
Boy, do I feel stupid?