OverviewSisense's default behavior is to use values directly from the Elasticube to set the X-Axis. But what if you want to do more? Modifying the x-axis labels is very easy and very flexible. Let's look at the base code.widget.on('render', function(...
ObjectiveDesign a quadrant chart based on X and Y axis averages with conditional formatting.StepsCreate standard scatter chartCreate a value in break by and assign the integer 1 to itCreate Aliases for multipasses by the Point dimension for the X and...
Purpose/BenefitSometimes it is convenient to always reset the filters to a default state when opening a dashboard. This post describes how to achieve this with a little bit of JavaScript. When users will often be resetting filters to a default stat...
Introduction When our chart x-axis have long labels, by default the SISense Web application will not render the entire label. For this, we can use the following script which wraps the text and breaks the text line for every other white space. In addi...
Render existing HTML code stored in your data modelFollow the steps below in order to URL clickable within a pivot table. Some steps are different depending on whether your Sisense instance is running on Windows or Linux. You can check whether your S...
Plugin Overview This plugin registers every page view from your Sisense instance to your Google Analytics account. https://analytics.google.com Configuration You must specify your Google Analytics "tracking ID" by editing the main.js file.By default...
When would I use this plugin?If there's a need to copy files from a remote server to the Sisense server before a build begins and delete them after the build is completed to save disk space. Useful for CSV and Excel files. Setting up the plugins:1) L...
Sometimes you might want to change the color of your pivot columns based on a condition - for example coloring the column in green if the cell's value is equal to a specific word and red if not:STEP 1 - ADD THE FOLLOWING SCRIPT TO YOUR PIVOT'S EDIT S...
IntroductionIn some cases you might have a URL’s in your fields in the cube, this post will show you how to modify URLs placed in rows of a Pivot table into clickable links.Purpose & BenefitsThis will allow you to jump to either internal or external...
Version: 1.4 DisclaimerUse the download Link for L2023.7 or newer. For older versions of Sisense, use the other attached version of the ColorHeatmap pluginIntroductionThis article explains how to install and configure the Color Heatmap widget as seen...
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...
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...
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, ...
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...
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; } });
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...
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) 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" 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 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...
