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 Could you please upload some dummy data so we have something to work with to provide a suggestion or solution?
@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.
I figured out a solution. Within each ethnicity group there are age variables that I can select to get the group needed.