I'm trying to take census tract linked data (in the form of a CSV I joined to a census tract level map of Washington State) and create a county-level map with it. My census data also has the county listed as a separate variable for each census tract (so basically what county each census tract belongs to). How can I take these census data and aggregate them to a county level in QGIS? More specifically, I'm trying to aggregate median income and percent of unemployment from the census level to the county level.
I've tried spatially joining the census map with the data to a county level map however the new values in the attribute table do not appear to be correct.
join attributes by location (summary)
instead of the simplejoin attributes by location