Knowledge
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Hide The Lines In A Pivot Table

The need is to hide the lines in the pivot as shown here:here is the code to do it:widget.on('ready', function(w, args) { $('.p-container .p-fixed-cols, .p-container .p-fixed-corner',element).css('border-right','0px solid'); });

intapiuser by Community Team Member
  • 341 Views
  • 0 comments
  • 0 kudos

Removing Value Labels And Markers From A Specific Series

When toggling the "value labels" switch of a widget's design pane, the labels are enabled or disabled for the entire chart.In case you have multiple series and you want to disable just one of them (typical when it gets too crowded on the plot), it is...

intapiuser by Community Team Member
  • 572 Views
  • 1 comments
  • 1 kudos

Zoomable Line Chart (Highcharts)

Download: Custom HighchartIntroduction This article explains how to import a zoomable line chart from Highcharts as a plugin in Sisense.Purpose/BenefitsIf you go to http://www.highcharts.com/demo, there are dozens of examples of how to implement High...

intapiuser by Community Team Member
  • 400 Views
  • 0 comments
  • 0 kudos

Horizontal Scroll Or Link Scroll On All Widgets In Dashboard

Here is a dashboard script that works for those pivot tables that have exactly the same structure. When you scroll one of them, all of them will reflect those scrolling changes.dashboard.on('widgetready', (el, args) => { $('.p-mid', 'widget[widgetid=...

intapiuser by Community Team Member
  • 314 Views
  • 0 comments
  • 0 kudos

Quadrant Analysis Plugin

Download: Quadrants Chart IntroductionThis article will explain how to change a Scatter Chart to a Four Quadrants Chart. It is an extension to the existing Scatter Chart and can only be applied to that widget.Business CaseThe Four Quadrants chart can...

intapiuser by Community Team Member
  • 193 Views
  • 0 comments
  • 0 kudos

Querying the Sisense Elasticube with Python

This article will cover two methods you can use to connect Python to the Elasticube. Method 1: Using ODBCMethod 2: Using the REST API Method 1: Connect to the EC with ODBC Download Sisense ODBC This method will require you to download the ODBC driver...

intapiuser by Community Team Member
  • 726 Views
  • 1 comments
  • 0 kudos

Tabs For Pivot Tables

The main intention is to organize the pivot table in case it has too many columns. The script will add a tabber that hides and show a specific set of columns. The code is completely fitted to our needs. If you want to use it, you have to replace ever...

intapiuser by Community Team Member
  • 465 Views
  • 0 comments
  • 0 kudos

Bookmarks

Download: Latest version (Sisense v7.0+), legacy version (Sisense v6) Introduction This article explains how to create filter bookmarks using Sisense. Purpose/Benefits It is easy for dashboard users to add/update filters on a given dashboard, but an ...

intapiuser by Community Team Member
  • 911 Views
  • 1 comments
  • 0 kudos

Set Max Value For Y Axis In A Chart

There might be cases where one needs to increase the height of the Y-Axis in a chart to ensure that the value labels are not removed while the chart is being responsive. The following script allows you to increase the max Y-Axis value by an X percent...

intapiuser by Community Team Member
  • 362 Views
  • 0 comments
  • 0 kudos

Custom No Result Plugin

Steps to Install: Download from my GitHub Download a ZIP of the project, Unzip the folder customNoResult-master, add it to your plugin folder, and rename the folder customNoResultDescription:This plugin will allow you to replace the No Result on a wi...

intapiuser by Community Team Member
  • 131 Views
  • 0 comments
  • 0 kudos

Area Line Chart Gradient

This widget script will add a gradient to the widget's area spline charts.Configure opacity and RGBA colors as per comments.widget.on('processresult', function(a,b){ // Set colors for the gradient in the "stops" section below. // The top color (first...

intapiuser by Community Team Member
  • 332 Views
  • 1 comments
  • 0 kudos

Remove Formulas Backgrounds

Download: Remove Formulas BackgroundThe plugin removes the blue background color from aggregations and calculations in the Advanced Formulas menu.STEPSSTEP 1 - ADD THE PLUGINDownload the attachment and unzip the contents into C:\Program Files\Sisense...

intapiuser by Community Team Member
  • 112 Views
  • 0 comments
  • 0 kudos

Grand/Subtotals For Specific Values In Pivot Widget

Download: Control Sub Grand Total Introduction The following forum post explains how to control Grand totals and Subtotals in the pivot widget. Purpose When we want to display Grand/Subtotal it's not always relevant for ALL values/columns, but only t...

intapiuser by Community Team Member
  • 1022 Views
  • 0 comments
  • 0 kudos

Adding Percentage Of Total For Column And Bar Charts

The column and bar charts allow you to add value labels to the bars. In the widget's design panel, you can turn on "Value Labels" to display the values on the chart itself. The picture below shows a typical example of a column chart, in this example ...

intapiuser by Community Team Member
  • 1156 Views
  • 1 comments
  • 0 kudos

Rotate And Wrap Text In X-Axis Labels

This post explains how to rotate and wrap text in the x-axis labels. Begin by copying the following code into the widget script. widget.on('beforeviewloaded', function(widget, args){ var newmaxCharactersPerLabel = 25; //Set length of the line length ...

intapiuser by Community Team Member
  • 323 Views
  • 0 comments
  • 0 kudos
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: