Knowledge Base

Custom Chart Options (Plugin To Easily Apply Highcharts Configuration Using Json)

Download: Custom Chart OptionsVersion: 1.0.0Created Oct-23-2019 by Steve Lewis (thanks to code re-used from Elliott Herz's Custom Bar/Column chart plugin) Current Version: V1.0.0 Tested on Sisense Version: V8.0.1.10112 Description: Sisense allows a c...

Adding A Regression Line To Chart

IntroductionRegression line helps us to predict values of one variable, when given values of another variable.Linear regression assists in predicting trends and improving data analysis.StepsA regression line can be added to all widgets with both y an...

Add Plus Sign To Column Chart Values (Tooltip)

You can accomplish it via JavaScript - you could make the value appear in that format within the data point tooltip of the column chart widget i.e. the box that appears when you hover over the columns.widget.on("beforedatapointtooltip", function (w, ...

Add Background Image To Charts

SET THE BACKGROUND OF CHARTS TO AN IMAGEOpen the script editor for a widget, and copy in the following code:widget.on('render', function(sender,event){ // URL to the background Image var imageLink = 'http://siliconangle.com/files/2014/12/BlackWhi...

Add A Plus Sign To Indicator Value

The simple script below will allow you to add a plus sign to the primary Indicator Value:widget.on('processresult', function(w, args) { var data = args.result.value.data; if(data > 0) { args.result.value.text = '+' + args.result.value.text; } });

Time Series Chart - Visualizing Hrs/Min/Sec

Download: Time SeriesIntroductionThe OOTB charts in Sisense limit the date roll-up granularity to days. This imposes limitations when working with granular times series data. This plugin facilitates roll-up of dates up to the millisecond level. It al...

Define Widget Navigator Scroll Position

In some cases, it may be desirable to define the default location of a widget's navigation scroll bar. Users will still have the ability to expand and move the navigation scroller, but anytime the dashboard is reloaded, the scroller will default to t...

How to Hide Export to Excel Option On a Pivot Table (Linux)

How to Hide Export to Excel Option On a Pivot Table (Linux) This article provides an example of a code snippet that could be used to hide a specific option from the Download menu on a widget level. If you find yourself needing to hide the export to ...

To display a solid line on the chart without using the "Display missing values as zeros" function

To display a solid line on the chart without using the "Display missing values as zeros" functionSometimes there is a need to display a solid line on the chart without using the "Display missing values as zeros" function. Here is a widget script that...

How to represent negative numbers with leading and trailing parentheses

How to represent negative numbers with leading and trailing parenthesesIn Accounting, it is common to represent negative numbers with leading and trailing parentheses.For example, negative two hundred is displayed as "(200)"Also, It incorporates a th...

How to set up a color palette in a dashboard URL for a specific user

How to set up a color palette in a dashboard URL for a specific user This article provides an example JavaScript solution that allows a user to define a color palette when a dashboard loads with palette={paletteID} in the dashboard URL. This way diff...

Dashboard Script for Automatic Filter Cascading

Dashboard Script for Automatic Filter Cascading This dashboard script below can be used to synchronize the selections of a set of filters. For example, if the first filter is set to ABC, all subsequent filters listed will automatically be updated to...

Animating Sisense Title Elements and Widgets Using CSS Animations

Animating Sisense Title Elements and Widgets Using CSS Animations Animating Sisense widget elements and dashboard/widget titles is a possible way to enhance the visual appeal and user experience of a Sisense dashboard or highlight a particul...

Color the cell based on the value

Here is the script on how to color the Pivot cell based on the value of this cell.For example color the cells that contains the value "True"://Text column formatting widget.on('ready', function(se, ev){ var evalCol = 12; //fidx val of column to eval...

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

JumpToDashboard - Troubleshooting the most common configuration issues

JumpToDashboard - Troubleshooting the most common configuration issues This article provides possible solutions to the most common configuration issues with the JumpToDashboard plugin. Please review the symptom of the issue first (what error/behavi...

How to use a widget.transformPivot function to change the background color of the entire row

This article provides an example JavaScript code snippet on how to use a widget.transformPivot function to change the background color of the entire row based on a value within that row. Please refer to the Sisense developer's documentation to learn...

JumpToDashboard Plugin - How to Use and Customize

JumpToDashboard Plugin - How to Use and Customize This article provides a detailed guide on how to use the JumpToDashboard plugin and describes its possible configurations. The guide covers the following topics: Get StartedCustomize your target (_dri...

Card View Customization

Before:After:Dashboard script for creating card view:dashboard.on('widgetready',function(d) { $('.dashboard-layout-column').css('background-color', '#f0f0f0'); $('.dashboard-layout').css('background-color', '#f0f0f0'); $('.dashboard-layout-c...

How to Remove/Hide a Full-Screen Button from the Widget

How to Remove/Hide a Full-Screen Button from the Widget This article explains how a user can hide, or remove, the 'Full-Screen' button from their widget toolbar. Please note that this button is available for users who are not the dashboard owner. Th...

Sisense Community

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Knowledge Base Articles