Knowledge Base

Pre And Post Build Plugin - Copy Files From A Remote Location Or Local Folder To Sisense Server And Delete After Build

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

Latest Date In A Pivot

Question: How to see the latest date in the Pivot? Solution: You need to change the date to an integer. Then I used the script in the comments in a previous post, and was able to request results. This is the script we used var m_names = new Arra...

Hide the widget's Button from the Toolbar for Viewer User

Hide the widget's Button from the Toolbar for Viewer UserWe will be learning how to hide information/additional buttons on the widgets from the Viewer user. Also, it is possible to hide these buttons from all users. For this press the 3 dots in the...

Dashboard Dictionary

Use Case My users and designers were looking for an easy way to get insights into how certain dashboards and widgets were built in terms of formulas and filters. Solution For this, I have written a Python script that takes a list of dashboard IDs...

How to change color of the links in Text widget?

How to change the color of the links in the Text widget?To change the color of the link, please do the following.Press 3 dots on the Text widget - Edit Script, paste next script, and press the Save button:const customStyle = { color: 'red' }; wi...

Changing Color Of Specific Cells In A Pivot Based On Textual Condition

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

Pivot2: "Clickable URL Links In Pivot Rows" Re-Implemented

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

Disable "Add To Pulse" Feature On Widgets

DISABLE "ADD TO PULSE" FEATURE ON WIDGETS FOR ALL VIEWERS Few businesses don't want their Users (Viewers) of the dashboard to add pulse alerts from the visualizations of the dashboard. Though we don't have any feature in the current version of the p...

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

Are there specs for the Marketing Banner size?

Are there specs for the Marketing Banner size? By default, the banner has a fixed height of 425px.As a reference, we suggest identifying a screen resolution you're planning to use with your application mostly. If you take the screen width and use it ...

Expanding on Using Native Javascript Date Calculations To Modify Sisense Date Filters

Expanding on Using Native Javascript Date Calculations To Modify Sisense Date Filters Sisense offers native support for various types of date filter functionalities and also allows users to create and modify dynamic filters entirely using dashboard...

Screen Shot 2024-01-30 at 5.04.56 PM.png

Using "useGetWidgetModel" to Embed an Existing widget in ComposeSDK

Using "useGetWidgetModel" to Embed an Existing Widget in ComposeSDK When developing ComposeSDK embedded applications, there are three principal techniques for embedding or converting an existing Sisense widget. Discussing each method, and some of th...

Screen Shot 2023-11-14 at 6.54.54 PM.png

Screen Shot 2023-11-18 at 4.53.33 PM.png

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; } });

5 Simple Rules for ElastiCube Design

Rules To Live By When Designing An Elasticube A list of recommendations which should be considered when developing an elasticube. Start Small Build your ElastiCube incrementally. Start with only two tables, create an appropriate relationship betw...

Blox Dropdown Placeholder

By default, BloX will use the first element in your dropdown as the default text in the dropdown box.Instead of this value, the following method adds a different default non-selectable value.Steps For ImplementationAdd the addPlaceholder class to you...

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

How to hide the "Switch to view mode" button based on a role

How to hide the "Switch to view mode" button based on a role This article provides an example JavaScript snippet that could hide the "Switch to view mode" button based on the user's role. How to use it? First of all, you need to get the role name y...

Sisense Community

Enable/disable field suggestions in the NLQ (Simple Ask)

Knowledge Base Articles