This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Download: Auto FilterIntroductionThis article explains how to automatically add a dashboard filter, based on the logged in user.Purpose/BenefitsIn order to provide a better user experience, you may want to automatically set a filter on your dashboard...
Version: 1.1 Download the plugin attached Introduction This article explains how to install and configure the Dynamic Dim/Value Chart plugin as seen below. The Dynamic Dim/Value chart allow Dashboard designers to predefine multiple dimension and/or...
Purpose/Benefits This plugin adds additional functionality on how one can display duration and date/time stamps in a Sisense indicator. Seconds to Duration takes the calculated integer and converts it to duration in hours, minutes, seconds, etc. ...
Download Zip: ExportTablesToCSVPostPlugin Files included: ectools.zipectools_sisense_ver<6.4.zip - (only for versions 6.4 and below)python-2.7.11.amd64.msiconfig_example.txtEC_export.dll This post explains how to install and configure the post plugi...
Use case: I have an image that I want to show markers on. To do this I'm using a scatter graph widget, where I use plotBackgroundImage to set an image to the background.In my dataset I have a set of items with x and y coordinates. However I don't hav...
You can show titles for legends in charts so that your users understand clearly which dimension is displayed in the chart.For example:Solution:To do this, apply the following code snippet on the widget level:widget.on("beforeviewloaded", function(sco...
Apply this widget script:widget.on('beforeviewloaded', (se, ev) => { let min = Math.abs(ev.options.yAxis[0].min); let max = Math.abs(ev.options.yAxis[0].max); max > min ? ev.options.yAxis[0].min = max *-1 : ev.options.yAxis[0].max = min; l...
Introduction Use this extension to plot a regression line within a chart. It works for Line, Bar, Column and Scatter charts. It is menu driven and does not require any script to be written. It will plot a regression line for each series in the cha...
Question: I would like to change the name of the subtotal titles.Solution: You can use the following Javascript on the widget level.var columns = ['0', '1']; //This is an array you can choose a specific column widget.on('ready', function(w, args) { ...
Download: Financejs.zip Introduction This plugin was created to enable additional financial calculations within a pivot table. The initial version of this plugin supports IRR, XIRR, & NPV functions that match what you would expect in Excel/Google S...
Download: Post Message Introduction The following forum post explains how to log your users out of Sisense from your native application. Purpose Single sign-on (SSO) systems enable your users to authenticate themselves in your online services and th...
The script below will collapse the dashboard and filter panes when a dashboard first loads. This is helpful when embedding with Iframe and you do not want these panes to show, but do not want to disable them for the user. Implementation Add the foll...
Introduction Using the following script we can set column chart values to their absolute valuesBefore:After:Script Place the following script in the column charts script:widget.on('processresult', function(w,e) { var s = e.result.series[0].data; ...
Introduction Many data sets include color descriptions of an item, such as a shirt color. This plugin allows sales of 'red' items to be displayed with a red data point.Implementation 1. Create the scatter chart you'd like to put this logic in2. In th...
Sharing a dashboard by using the REST API is very useful in case you need to automate the sharing process.However, in order to do so more than one API call is required, and not using them all in the right order will result in an unsuccessful share.Sh...
Download: Filter MeasureIntroductionThis article will explain how to disregard a widget from a certain filter + the ability to define a specific measure to be affected by this filterBusiness CaseHaving only a specific measure to be affected by a filt...
Download: JAQL Butler Purpose/Benefits When your data model contains multiple fact tables, it can add challenges regarding filters. Consider the following data model. This Elasticube contains data from several fact tables (coming from Google Adw...
In many databases, the length in time of an action is stored as an integer. This allows for more analytic operations to be performed against the data, such as averages. However, we may want to present this information in a standard time format. (E....
In some cases for design or reporting you would like to control the size of your pivot2 columns.The example bellow is for a table with 4 columns 0-3:// Add new width for desired columns // Columns count should start from 0 var newWidth = { 0: 100, 1:...
Introduction:On the top panel of a dashboard you can see the date and time an ElastiCube was last updated. You can change the color of this text to green or red based on parameters using the script below. For instance, this script checks if the Elast...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
