Data Limits for SAS Visual Analytics Explorer

Some of the visualizations in SAS Visual Analytics Explorer (the explorer) have limits to the number of data values that they can display. The limit values are affected by the Visualization data threshold setting in the Preferences window. For more information about the Preferences window, see Specify Your Preferences for the Explorer.

The following table displays the data limits for visualizations in the explorer:

Data Limits for the Explorer
Visualization Type	Variation	Behavior when Limit Is Exceeded	Default Threshold	Minimum Threshold	Maximum Threshold
Table	—	Paging is applied to the table.	10,000	1,000	100,000
Crosstab	—	An error message appears.	21,000,000 cells	1,000,000 cells	26,000,000 cells
Bar Chart	Not grouped or latticed.	The bar chart shows a subset that contains the first or last ranked values.	3,000	810	3,625
Bar Chart	Grouped or latticed.	An error message appears.	3,000	810	3,625
Line Chart	Single numeric or datetime category in the Category role.	The line chart shows a subset that contains the first or last ranked value.	10,000	5,630	11,250
	Single string category in the Category role.		4,000	1,380	4,750
	No string categories in the Category role, grouped or latticed.	An error message appears.	10,000	5,630	11,250
	One or more string categories in the Category role, grouped or latticed.	An error message appears.	4,000	1,380	4,750
Scatter Plot	Two measures, not grouped.	The scatter plot is converted to a heat map.	40,000	9,375	48,750
	Two measures, grouped.	An error message appears.	40,000	9,375	48,750
	Three or more measures, not grouped.	The scatter plot is converted to a correlation matrix.	80,000 / number of measures	18,750 / number of measures	97,500 / number of measures
	Three or more measures, grouped.	An error message appears.	80,000 / number of measures	18,750 / number of measures	97,500 / number of measures
Bubble Plot	No categories.	The bubble plot is converted to a heat map.	25,000	7,500	30,000
	Grouped.	The bubble plot shows the top or bottom value by size.	500	150	600
	Latticed.	An error message appears.	1,050	4,900	50,000
	Grouped and latticed.		500	150	600
	Animated.		50,000	15,000	60,000
Network Plot	—	An error message appears.	8,000	100	10,000
Network Plot	—	An error message appears.	1,000 nodes, 1,000 links
Sankey Diagram	—	An error message appears.	3,000 links	500 links	3,625 links
Sankey Diagram	—	An error message appears.	8,020 rows	1,000 rows	10,000 rows
Histogram	—	—	None	None	None
Box Plot	—	An error message appears.	2,900 boxes	800 boxes	3,500 boxes
Heat Map	No categories.	—	None	None	None
Heat Map	One or more categories.	An error message appears.	3,000	1,250	3,500
Geo Map	Bubble overlay.	The bubble overlay is converted to a coordinate overlay.	5,000	1,500	6,000
	Region overlay.	The region overlay is converted to a coordinate overlay.	5,000	1,500	6,000
	Coordinate overlay.	An error message appears.	82,000	10,000	100,000
Treemap	No additional levels.	The treemap shows a subset that contains the first or last ranked value.	4,900	1,050	6,000
Treemap	One or more additional levels.	The number of additional levels is reduced to 0. If the threshold is still exceeded, then the treemap shows a subset that contains the first or last ranked value.	4,900	1,050	6,000
Correlation Matrix	—	—	60 measures
Decision Tree	Number of nodes.	An error message appears.	180	75	200
	Number of target values.	The decision tree displays truncated data.	50	30	50
	Number of predictor values.	An error message appears.	4,300	1,500	5,000
Word Cloud	—	The word cloud displays the top words by frequency, by measure value, or by topic weight.	100	100	100

In addition to the data thresholds that are set by the Preferences window, there are server data limits that can be set by the system administrator. For information about the server data limits, see the topic “Manage High-Cardinality Data” in the SAS Visual Analytics: Administration Guide.