If your data contain empty values or errors, or if filtering has reduced the number of valid rows too much, the data relationships calculation may result in errors for specific cells in the table. The available error codes are described below:
Error Code |
Description |
#No valid pairs |
There were no valid rows to calculate on. This may occur if you have filtered out too many rows, or if the two compared columns have a different set of valid rows on which to perform the calculation only. |
#Only one valid pair |
There were not enough valid rows to perform a calculation. See above. |
#Only two valid pairs |
There were not enough valid rows to perform a calculation. The number of valid pairs must be larger than two. See '#No valid pairs' above. |
#Only one unique value for column '{0}' |
This happens if the number of unique values equals one. |
#More than 1000 unique values for categorical column '{0}' |
Categorical data relationships methods, i.e., Anova, Kruskal-Wallis and Chi-square, cannot be used on columns where the number of unique values is larger than 1000. In that case, the number of categories to split by becomes too large. |
#All values unique for column '{0}' |
Categorical data relationships methods, i.e., Anova, Kruskal-Wallis and Chi-square, cannot be used if you only have a single value within each category. |
See also: