Issues in detecting patterns in the granular data

[nathan_love]

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.png

After:

image.png