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'); });
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...
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...
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=...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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 ...
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 ...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
Share this page:
