Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Auto Insights Knowledge Base

Definitive answers from Auto Insights experts

Issues in detecting patterns in the granular data

nathan_love
Alteryx
Alteryx
Created

Issue

I have too many variables in one field, which makes it hard to get accurate information when looking at what caused this.

Cause

The data you currently have is too granular, resulting in a limited sample size across multiple categories which makes it hard for Auto Insights to detect patterns in your data.

Resolution

Convert your data to have fewer categories within the one field. A typical example is turning an age field, into a grouped aged field (see example below)
The best way to create these is with a Formula Tool and using an IF formula.

Before:
image.pngimage.png

After:

image.pngimage.png