Select certain age group based on trade area/ethnicity breakdown
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Labels:
- Demographic Analysis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@hprice Could you please upload some dummy data so we have something to work with to provide a suggestion or solution?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I figured out a solution. Within each ethnicity group there are age variables that I can select to get the group needed.
