I am using QGIS 3.16.12.
I have a dataset of 150 retail companies, each selling a product over 100 counties across the country. This dataset also includes data on the number of sales per county for each company. I merged this dataset into the U.S counties shapefile. Below is an snapshot of the shapefile attribute table.
I’d like to create a map per company (150 maps in total) using Atlas that indicates the number of sales across the U.S. For instance, when I generate company A's map using the entire country's map (like the snapshot below), I'd like to see the number of sales at the county level that it operates regardless of how many counties it's operating in. In order words, I don't want the maps get zoomed into only the counties that it operates, but rather I want to see it across the entire country's map so I can do a comparison between companies country wide like this:
Could you please tell me what steps I need to do next in order to achieve what I am intending to do? because when I select the shapefile mentioned above in Atlas as coverage layer and Company_ID as page layer, it doesn't uniquely identify each company like the image here: