This question is specific to Google Sheets—hopefully I’m in the right place.
https://docs.google.com/spreadsheets/d/161rtpjNK5363-U6y6MZYzqOIx7CQBCHDWInBXFtZYIg/edit?usp=sharing
As you’ll see above, I have a load of raw site-speed ‘milestone’ timing data for (TTFB, Load, etc.). The graphs I’ve generated so far are the dead easy ones: for each page type, show me all milestones from all countries. Each page type has a corresponding graph. This shows me useful things like ‘on the Shop page, load times are consistent across the world’ or ‘PDPs load much faster in SE Asia’.
The graphs I’m not sure how to generate are ones where each country has its own corresponding chart. For each country show me all milestones for all page types. This will show me information like ‘in Japan, X has the highest TTFB’ or ‘shop pages load much slower than the homepage in Y’. Does that make sense?
I’m worried I may have simply structured my raw data ineffectively in the Sheet, but I’m also pretty clueless about Sheets in general so it could be any number of things I’m getting wrong.
To make things a little clearer, this is the type of chart I’m looking to produce.