Explain Data: Status Information
When you run Explain Data on a mark, a statistical analysis is run on the aggregated mark, and then on possibly related fields from the data source that aren't represented in the current view.
Explain Data does not include every column from the data source in the analysis. The status bar indicates the number of fields considered in the analysis, and the information tooltip indicates which fields weren't included. In many cases, certain types of fields will be automatically excluded from the analysis.
When a data source contains more than unvisualized 1000 dimensions or measures, you might see an alert asking if you want Explain Data to consider more fields. Click Explain All to run an analysis that includes more fields.
When a data source contains dimensions with a large number of unique values (up to 500), those fields will not be considered for analysis initially. You can select which fields are included for consideration by clicking the Choose fields for<YourDataSourceName> link in the status bar, or by clicking the Data menu, and then selecting <YourDataSourceName> > Choose Fields for Explain Data.
Note: Dimensions with more than 500 unique values will not be considered for analysis.
For more information on using Explain Data, see Inspect a View with Explain Data(Link opens in a new window).
Fields excluded by default
|Fields excluded by default||why|
All unvisualized measures when there are more than 1,000 measures in the data source.
All unvisualized dimensions when there are more than 1,000 dimensions in the data source.
Computing explanations for more than 1000 unvisualized measures or dimensions can take longer to compute, sometimes several minutes. These fields are excluded by default for initial analysis, but you can choose to include them for further analysis.
In this situation, you might see an alert asking if you want Explain Data to consider more fields. Click the alert link to get more information. Click Explain All in the resulting tooltip to run an analysis that includes more fields.
|Fields that use geometry, latitude, or longitude||It is highly likely that an explanation that calls out the latitude or the longitude as an explanation is due to a spurious correlation and not a probable explanation. Geometry, latitude, or longitude by themselves can never be explanations.|
|Dimensions with high cardinality (dimensions with > 500 members)||
High cardinality dimensions take longer to compute. Dimensions with more than 500 unique values will not be considered for analysis.
|Groups, bins, or sets||Not currently supported.|
|Table calculations||Cannot be analyzed when table calculations are at a different level of detail than the view.|
|Unvisualized measures that can't be averaged||Unvisualized measures that can't be averaged include measures that are calculated fields where the calculation expression includes aggregations (display as AGG() fields when added to the sheet).|
|Discrete measures and continuous dimensions||Not currently supported.|
|Hidden fields||Not available.|
|Calculated fields with errors||No values present to analyze.|