Creating dynamic hyperlinks on Pivot2 tables without updating the data model These two articles provide options to create hyperlinks (clickable texts) on pivot tables: Clickable URL Links In Pivot RowsPivot2: "Clickable URL Links In Pivot Rows" Re-Im...
Enable/disable field suggestions in the NLQ (Simple Ask) For the latest version of Sisense like L2024.x to have a field suggestion, you need to enable it. First of all, what is the field suggestion, as illustrated by the picture below, if...
Steps to Install:Download from my GitHubDownload a ZIP of the project, Unzip the folder customNoResult-master, add it to your plugin folder, and rename the folder customNoResultDescription:This plugin will allow you to replace the No Result on a widg...
Custom sort for Bar and Column ChartQuestion:I have seen several posts of people asking if there is a simple way to apply custom sorts for car and column charts, and until recently, I have been using the community customBarColumnChart Plugin, which i...
How to unblock users after failed login attempts Protecting user credentials can't be overstated in any secure system. Security measures such as locking users after multiple failed login attempts are critical in preventing brute-force attacks. Howe...
Customizing Upper Label (PlotBands) Labels in Sisense Column Chart Widgets for Long Category Labels Sisense allows customization of chart settings through Highchart option configurations, as documented in this community post leveraging the Highchart...
Use case You have specific libraries in Notebooks that have to be installed to run Custom code tables. However, these libraries can be uninstalled automatically (during upgrade or other system changes). Solution Add the following Python code into th...
Sisense application logs The Sisense Support team typically uses the application log data to investigate outages, troubleshoot bugs, or analyze reported issues. Analyzing application logs can help the Support team determine the root cause of inciden...
Reading multiple Excel files into Sisense data model Introduction: If you are migrating from Windows to a Sisense Linux-hosted solution, on the Sisense Windows machine you may use an SFTP client that moves Excel files placed in a remote server's fol...
Creating a Year-Over-Year Chart in Sisense Summary This article addresses the issue of creating a year-over-year comparing chart in Sisense that shows a Key Performance Indicator (KPI) for the current calendar year against the previous calendar year...
The error "cp: cannot create regular file '/usr/local/bin/kubectl': Text file busy" typically occurs when multiple upgrade processes are running simultaneously, causing a conflict when trying to update the kubectl binary. [2024-10-30 12:33:34...
Advanced Scripting for Sisense’s Simply Ask NLQ: Adding Currency Symbols to Pivot TablesSisense’s Simply Ask feature empowers users to create visualizations instantly by asking natural language questions, simplifying data exploration without needing ...
Introduction:The below article will provide a BloX template that will help you create a dropdown filter The ‘Dynamic Dropdown’ snippet allows you to populate your dropdown list with a list of values from a specific field (for example, list of Brands)...
**Please refer to the following article for extended functionality: Performing a Front End Left Join ** This article presents a data modeling based solution that may allow you to create a simple Left join within one certain widget. Custom SQL Table...
Automated Machine Learning with Sisense Fusion: A Practical Guide In this article, we’ll explore how using Sisense and AutoML (Automated Machine Learning) can simplify the process of applying machine learning to real-world business problems. AutoML ...
Calculate the Average for the indicator as on the pivot with the filter To calculate the average value for the indicator and get the same result as in the Pivot, we use the simple AVG formula in both cases and get the correct result. But if we will...
Blox with drop-down and All values in it Sometimes we need to have an All values option for our dropdown menu in the BLOX. Especially if we just open the dashboard and filter set to Include all. To create it, press the pencil icon to edit the wid...
Group values are on the column chart by day of the week. We will check how to convert the usual Column chart with values and dates into a new chart with dates and values grouped by day of the week. For example, we have such a chart We want to see th...
Customizing the Offset Size of Selected Categories in Sisense Pie Chart Widgets In Sisense, pie chart widgets, including the various pie chart style options such as donut charts, are a common way to visualize data. By default, when a user selects a...
Threshold-Based Conditional Plot Bands Colors For Cartesian and Polar ChartsPlot bands in charts are visual elements that highlight specific ranges along the x-axis or y-axis, usually to emphasize certain areas of interest. These bands are typically ...
