I want to sort page numbers correctly, as numbers and not as text. Page number is the dimension and event count the metric.
I think you may need to create a calculated field to sort properly. You can either use the CAST function to cast the string as a number, or use the CONCAT function to add leading zeroes to the string as suggested in a similar post.