User Parameters Use Case - Automatic Time Zone Conversion This article explains one of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cases). In addition to connection settings,...
Download linkThe Color Manager plugin, originally by Tommy, is a great plugin which allows you to define specific colors for specific categories (and not to values, which is the way Sisense works by default). Furthermore, the colors you specify for a...
Disclaimer: Please note that this blog post contains one possible custom workaround solution for users with similar use cases. We cannot guarantee that the custom code solution described in this post will work in every scenario or with every Sisense ...
This article covers the steps to change the date granularity of a widget using BloX actions along with the dropdown input of BloX. In this post, we shall achieve the functionality with the help of single-select BloX buttons that has some color animat...
User Parameters Use Case - Enforcing Data Isolation / Row-Level Security Rules from Source DatabaseThis article explains two of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cas...
How to List Dashboards and Data Models a User Has Access ToAs a Sisense administrator sometimes you want a quick way to get the list of data models and dashboards a user can access. There is no direct way to do this through the user interface and thr...
Plugin - Disable Link To Sisense Server Homepage In Top Left Logo Icon This plugin disables the link to the home page of the top left logo in the Sisense UI. The plugin also removes the logo icon being treated as a link on mouse hover. This logo im...
Download: GIPHY WIDGETINTRODUCTIONThis article explains how to install and use the giphy widget.This is an extension of the existing image widget allowing you to define a keyword and with the giphy api display a random image driven by the keyword. W...
Three tips for new users working with Sisense's REST API for the first time.1. If you're running API calls through our Swagger UI (ie, by going to Admin -> REST API -> REST API Reference), you do not need to generate and pass an authentication token....
How to Customize Pie/Bar/Column/Area/Line Chart Data Labels If you find yourself needing to modify data labels on a widget, and the built-in capabilities do not allow you to achieve your goal, it might be possible to customize those values with the ...
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...
Troubleshooting Compose SDK Setup Issues Below are some issues you may run into when setting up a TypeScript+React app to use Compose SDK packages and how you may troubleshoot them. Most of them are related to the app configurations as opposed to SD...
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...
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 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...
