Change Axis/Series Data Limitation
Introduction
This article explains how to change default data limitation of X and Y axis for scatter charts.
When there are too many categories in the X/Y axis or too many series, Sisense limits the number of categories/series to display.
Steps
STEP 1 - CREATE WIDGET
Create a scatter chart widget
STEP 2 - ADD SCRIPT
Add the following script to the widget by editing the widget script:
widget.on('beforequery', function(w,args){
w.style.dataLimits.categoriesCapacityX = 80;// Or any other number
w.style.dataLimits.categoriesCapacityY = 80; // Or any other number
w.style.dataLimits.seriesCapacity = 100; // Or any other number
});
w.style.dataLimits.categoriesCapacityX = 80;// Or any other number
w.style.dataLimits.categoriesCapacityY = 80; // Or any other number
w.style.dataLimits.seriesCapacity = 100; // Or any other number
});
For example:
Given the following widget:
After adding the following script to the widget:
widget.on('beforequery', function(w,args){
w.style.dataLimits.seriesCapacity = 190;
});
w.style.dataLimits.seriesCapacity = 190;
});
We will get the following result:
Notes
Too many series/categories can cause :
- Performance issues
- UI issues such as: labels are too small, markers are drown on top of other markers.
Updated 03-02-2023
