Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Select certain age group based on trade area/ethnicity breakdown

hprice
Météoroïde

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?

4 RÉPONSES 4
Prometheus
Quasar

@hprice Could you please upload some dummy data so we have something to work with to provide a suggestion or solution?

hprice
Météoroïde

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.

Prometheus
Quasar

@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
Météoroïde

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

Étiquettes
Auteurs des meilleures solutions