Select certain age group based on trade area/ethnicity breakdown

Question

Our HR team asked if we could recreate a report that Experian had been providing that breaks down ethnicity by store location. It was done at a 25 mile radius. I have the ethnicity breakdown by location figured out. The piece that's throwing me, is an additional filter Experian added to only include people 65 and under. Is this doable with Alteryx or was this only something Experian can do with access to the raw data?

hprice · Answer

I figured out a solution. Within each ethnicity group there are age variables that I can select to get the group needed.

Prometheus · Answer

@hprice These fields are all counts of people of certain races/ethnicities. There's nothing about age. If you can get a dataset that contains a field identifying age, then you can filter it out.

hprice · Answer

Output from Alteryx is attached. What I need to be able to do is, filter out anyone that is over 65 from the data. Not sure if that's doable with what Experian provides in the data package.

Trade Area 25 Mile Demographics - for user group.xlsx