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 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...
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...
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...
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? 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 Sisense offers native support for various types of date filter functionalities and also allows users to create and modify dynamic filters entirely using dashboard...
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...
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; } });
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...
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...
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 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...
Script to retrieve the user list with first name and last, email, and userID. By following these instructions, users can efficiently check and download a CSV file containing the list of users meeting specific criteria from the developer console in ...
Symptoms Sometimes with a pivot table full of many columns with zero and only a few non-zero values, you want the zeroes to display as empty-string. That way the nonzero values really stand out. (This is the opposite of this: Solved: nulls to 0 in...
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...
