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: *...
In cases where we want to display the difference between two columns instead of using the default Grand Totals in Pivot widgets:Include the following widget script:function removeCommas(num){ numClean = num.replace(/,/g,""); return numClean; }; w...
The goal is to allow users to dynamically choose a dimension. The below script will work with a table or a pivot table, but it can be modified to work with other widget types as well. Step 1Create a BloX widget with the below script. It will consist ...
Question:In pivot tables, we would like to show column grand totals on top of the table and row grand totals at front. Please let us know how to alter positions.Asnwer:This script will move the grand total row to the top. widget.on('ready', function...
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...
Creating and deleting EKS cluster in the existing VPC Introduction: This guide demonstrates how to create an Amazon EKS (Elastic Kubernetes Service) cluster within existing VPCs and subnets, and how to remove it using the same configuration file wit...
Version: 1.4 DisclaimerUse the download Link for L2023.7 or newer. For older versions of Sisense, use the other attached version of the ColorHeatmap pluginIntroductionThis article explains how to install and configure the Color Heatmap widget as seen...
Tabber - Troubleshooting The Most Common IssuesIntroductionThis article provides troubleshooting steps for the most common issues with the Tabber add-on. Search for the relevant symptom and review the solution that might help resolve the issue.Step-b...
Plugin – RemoveImageDownload – Removing Items From Sisense MenusThis article discusses a plugin (and an equivalent dashboard script) that removes the “Download as Image” option from Sisense menus. This same approach can be applied to remove any other...
How to Implement Linkable Text in a Widget (Linux)IntroductionThis article provides a guide on implementing linkable text to navigate to another dashboard in Sisense. The goal is to enable users to access a linked dashboard by clicking on a text elem...
Optimizing Docker StorageManaging Docker images, containers, and volumes efficiently is crucial tomaintaining disk space and system performance. Over time, unused Docker objectsaccumulate, leading to storage bloat and inefficiencies. By default, Dock...
Resolving Missing Generic JDBC Connector in SisenseThis article addresses the issue where the Generic JDBC connector is not visible under available connectors for users logged in with a designer account in Sisense version 2023.6 or newer. This proble...
Hide vertical lines on the Pivot widget To test this solution, you must create a dashboard based on any cube and create any Pivot widget. Once it is done - please go to the widget editor, click three dots select Edit Script, then paste the following ...
Auto zoom Area Map widget to a specific country on loadTo test this solution, you must create a dashboard based on Sample ECommerce and an Area Map widget based on a Country column. Once it is done - please go to the widget editor, click three dots s...
Mongo issue and their possible solutions The query translated from SQL to MQL is adding additional unnecessary parameter {"$not": {"$type": 2}} randomly. This leads to the following consequences: index is not included in the execution plan full tabl...
Resolving Missing Parse Option in SQL DB ConnectionThis article addresses the issue of the missing "Parse" option when connecting to an SQL database in Sisense. Users may encounter this problem when attempting to parse data from SQL DB connections. T...
403 error in UI when trying to change the Excel connection to upload a new fileThis article describes what you should check when encountering a 403 error when trying to change an Excel connection to a new source file.Possible root causeThe error can ...
Resolving DBLink Issues in Sisense for Postgres Connections This article addresses the issue of using DBLink with Postgres connections in Sisense. DBLink is a feature in PostgreSQL that allows users to connect and query data across different database...
Resolving Missing Generic JDBC Connector in Sisense This article addresses the issue where the Generic JDBC connector is not visible under available connectors for users logged in with a designer account in Sisense version 2023.6 or newer. This probl...
Managing Sisense Add-ons: Upgrades, and Version ControlIntroductionThis article describes how certified add-ons are upgraded in Sisense. Additionally, this guide will help you address questions related to add-on versions, such as when different versi...
