Change Axis/Series Data Limitation

[intapiuser]

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
});

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;
});

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.