Change Axis/Series Data Limitation

Follow

shani adani

January 19, 2016 16:46

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...

0

• 

  Jim Thomas July 19, 2016 20:58

  Shani - works great on Scatter charts, but does not resolve the "Too many ticks" issue on Bar charts.  See screen shot attached.  Do you have one for that?  Thanks, Jim

  
  
  
  Sisense-Too Many Ticks error.png

  0

  Comment actions Permalink
• 

  shani adani July 20, 2016 04:15

  Jim,

  You can try to change the w.style.dataLimits.categoriesCapacity  parameter also.

  It should do the work.

  0

  Comment actions Permalink
• 

  Jim Thomas July 20, 2016 12:50

  Shani,

  Added it.  Script is now:

  widget.on('beforequery', function(w,args){
      w.style.dataLimits.categoriesCapacityX = 5000;// Or any other number
      w.style.dataLimits.categoriesCapacityY = 5000; // Or any other number
      w.style.dataLimits.seriesCapacity = 5000; // Or any other number
      w.style.dataLimits.categoriesCapacity  = 5000;
  });

   

  Unfortunately it did not resolve the issue.  Note that this issue occurs on drill.  Wouldn't have thought that matters, but wanted to mention.

  Regards, Jim

  0

  Comment actions Permalink
• 

  Jim Thomas December 18, 2017 16:24

  Shani,

  Has this been resolved for v6.7.1 for scatter diagrams?  It's not working for me.  In my particular instance, both the series and number of categories are exceeded.

  Thanks, Jim

  0

  Comment actions Permalink
• 

  Oxana Noa Umansky December 28, 2017 17:19

  Hi Jim,

  We've tried the script in 6.7.1 and looks like it's working as expected. Are you still experiencing the issue? Can you share more info to help us troubleshoot? 

  0

  Comment actions Permalink
• 

  Jim Thomas December 28, 2017 22:50

  Oxana - Using the script above I get the following error on a scatter.  Thanks - Jim

  

  0

  Comment actions Permalink

Please sign in to leave a comment.