edit: I didn't read the whole question. :facepalm: But basically, grouping by the day of week in place of date should get you where you want to go. Start with the query you posted above, then use that ...
Google announced Query groups in Search Console Insights. The AI feature clusters similar search queries, surfaces trends, and shows which topics drive clicks. Query groups uses AI to cluster similar ...
This is available in Search Console Insights and gives you a quick way to see the main topics your website is about. Google added Query groups to the Search Console Insights report. Query groups ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results