How to Use "OR" Filter Condition on a Widget Level | JavaScript This article provides an example JavaScript code snippet to have the ability to use the "OR" filter condition on a widget level. Currently, the Filter Relations Editor in Sisense allows...
Question How to Calculate YTD by Month in a Pivot Table? Answer If you want to show YTD by Month next to your monthly amount you can utilize the "Running Sum" Quick Calculation. If you want to show this next to the monthly amount, just bring in th...
Restoring missing connector Introduction Sometimes connectors can go missing for some reason, leading to a breakdown in data connectivity. Restoring these connectors is crucial to maintaining a smooth data flow within your Sisense environment. This...
Plugin - Custom Coloring of Bar and Column chart-type widgets This plugin modifies the color scheme of bar and column chart-type widgets to match the current color palette of the dashboard. Installation To install this plugin, download and unz...
This article will explain how to create reset to default filters button in BloX This helps in case you want to provide this icon functionality on the dashboard and not just in the Filters panel. Create a new custom action with the below code: *...
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...
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...
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...
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...
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...
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...
Using the Color Palette Parameter of Sisense Dashboards in Scripts and Plugins Like many other dashboard parameters, the color palette of a Sisense dashboard can be accessed and modified in scripts and plugins for customization and addi...
This article describes how the append dashboard filters as URL params to apply scope automatically to embedded dashboards. The example below shows how to apply members as filters. If you already have dashboard filters defined, you can write the f...
Migrating Blox Custom Actions When relocating Sisense resources from one server to another, the Sisense Rest API is a possible method for transferring Sisense components and objects like dashboards, users, groups, and data sources. Similarly, Blo...
This dashboard script allows you to add subtitles/description right under the widget title. To add a subtitle/description add ' - ' after the widget title, followed by the subtitle text. Long text will automatically wrap. To add another line break wi...
Sisense doesn't currently support filtering on timestamps natively. This article shows how we can leverage BloX to work around this limitation and allow users to select a date and timestamp range to filter their dashboards. (This is an updated versio...
This article will show you how to quickly color a pivot table into two sections: by Row and by Value1. Build your pivot table. 2. In the widget editor, add the widget script below. Information on how to add a widget script here: https://sisense.dev/...
Using the "desc" Description Parameter of a Sisense Dashboard via the REST API and the Dashboard Javascript Object The description parameter ("desc") of the Sisense dashboard object is notable for its somewhat unique characteristic – it's not access...
If you've ever attempted to dynamically resize your embedded iFrames in your parent application, you may have experienced a CORS conflict. Basically, since your parent application and sisense application serve from different domains, your browser re...
