Retrieve top hit URLs

For the purpose of a “most viewed” posts widget, I’d be interested into knowing how far can the Analytics API be pushed.

I imagined I could fetch the top-5 URLs (matching a pattern like /news/*) during the last X months and retrieve their respective number of hits from the Analytics API.

Since this API is completely based on GraphQL and I couldn’t, from a first look, know whether such data is available nor if they could be aggregated/sorted/filtered in such a way, I’d like to ask here if a CF Analytics GraphQL expert could provide some information about the feasibility (and/or some GraphQL sample requests)?

Thank you