Filter by country including rest of the world
I'm trying to build a report which includes just a few countries, but I want that the percentage is calculated on the total (including countries which are excluded by the filter). Example: I want to know the % number of Sessions from US and UK compared to the total.
Right now if I add as filter "United States|UK" I get something like:
"US 80% UK 20%"
I want to know the percentage on the overall number of Sessions so:
"US 20% UK 5%"
Ideally the best report would be:
"US 20% UK 5% Other countries 75%"
Is it possible to achieve something like that with Google Analytics?
Re: Filter by country including rest of the world
You can use segments as AT points out but you will still have to do some math and include all users in addition to your custom segment. Alternatively you could create two dashboard widgets one filtered for the countries in question and one that is not (or do this in data studio).
Lastly, you could use the API and pull the data into Google Sheets using the GA plugin and call all data, then just the countries you want and do this in a calculation.