Knowledge Base

Mastering custom actions in Sisense: debugging and understanding payload properties

Mastering custom actions in Sisense: debugging and understanding payload propertiesWhen you use a custom action from the community, develop your own, or try to understand why your action does not work as expected, sometimes you need to change the cus...

Setting Date Filter Members to Specific Days of the Week in Sisense Programmatically

Setting Date Filter Members to Specific Days of the Week in Sisense Programmatically Sisense natively supports a wide range of date filter functionalities and formats. However, certain scenarios may call for unusual custom programmatic forms of da...

Screenshot 2024-11-21 at 11.11.13 AM.png

Line Chart - Customizing a line to various "Dotted" styles

When creating a line chart, a certain line might require a different style. For example - A line that shows a threshold should be styled as a dotted line The following widget & widget script can be used to customize your line chart: widget.on('proce...

Controlling JAQL Timeout | Linux

Controlling JAQL Timeout | Linux Please note this article is for Linux users. What You’ll Learn Main Properties of a JAQL requestWhen the JaqlPool parameters for managing JAQL request timeouts are triggeredWhen to change the default values for these...

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense When working with Sisense dashboards, programmatically modifying filters upon dashboard load via dashboard scripts for a specific user or circu...

Using Native Javascript Date Calculations To Modify Sisense Date Filters

Using Native Javascript Date Calculations To Modify Sisense Date Filters Sisense natively supports various types of date filter functionalities. However, there are instances where a dynamically updating date filter is desired based on dynamically ch...

Screen Shot 2023-11-21 at 7.30.17 PM.png

How to resolve browser freezing issues (page unresponsive) on your dashboards

How to resolve browser freezing issues (page unresponsive) on your dashboards This article addresses the issue of web pages freezing and becoming unresponsive when users interact with certain Sisense dashboards. It typically occurs when the browser i...

Show full date format in the pivot or table widget

Show full date format in the pivot or table widget If you want to show the full date format, like 2024-11-20 18:00:00 in the Pivot or Table widget, please do the following: 1. Go to the elasticube find the Date column and duplicate it ALT text: A us...

Creating dynamic hyperlinks on Pivot2 tables without updating the data model

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...

Screenshot 2024-11-17 at 12.21.21 AM.png

Screenshot 2024-11-17 at 12.23.35 AM.jpg

Enable/disable field suggestions in the NLQ (Simple Ask)

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...

Customizing Upper Label (PlotBands) Labels in Sisense Column Chart Widgets for Long Category Labels

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...

Creating a Year-Over-Year Chart in Sisense

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...

Advanced Scripting for Sisense’s Simply Ask NLQ: Adding Currency Symbols to Pivot Tables

Advanced Scripting for Sisense’s Simply Ask NLQ: Adding Currency Symbols to Pivot Tables Sisense’s Simply Ask feature empowers users to create visualizations instantly by asking natural language questions, simplifying data exploration without needi...

Customizing the Offset Size of Selected Categories in Sisense Pie Chart Widgets

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...

Modifying Simply Ask Natural Language Query Generated Widgets with Scripting

Modifying Simply Ask Natural Language Query Generated Widgets with Scripting Sisense's Simply Ask feature empowers users to create visualizations instantly by asking natural language questions, simplifying data exploration without needing technical ...

Replace Values with Text - Pivot Table Widget

Introduction The following enables to change the value in pivot tables to specific strings, while allowing the use of conditional coloring as normal. Step 1 - Add The Following Script To Your Pivot's Edit Script widget.on('ready', function(){ $('...

Resolving resize widget Issue when the Tabber Widget is in use

Resolving the resize widget Issue when the Tabber Widget is in use Step-by-Step Instructions to Resolve the Issue Identify the Problem: Confirm that the issue is with the Tabber widget not allowing the resizing of other widgets on the dashboard. D...

Limiting Date Range Filters in Sisense Dashboards

Limiting Date Range Filters in Sisense Dashboards Use Case Overview Wide date ranges in Sisense dashboards can lead to performance issues, especially when using live models or querying large datasets. For live data models, large queries increase cost...

Changing Measures In The Entire Dashboard Using Blox User Interface

Objective Display several related values (KPIs/Measures) in multiple widgets in the dashboard based on the user selection, in a simple and easy way, without duplicating widgets/formulas or tables in the Elasticube. As a direct result - the queries b...

Plugin - customLogoLink

Plugin - Set Custom Link Overriding default In Top Left Logo Icon Description This plugin allows changing the link of the top-left Sisense or white-labeled logo on the server's home page to a custom URL. Disabling the plugin will restore the log...

Sisense Community

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Knowledge Base Articles

Mastering custom actions in Sisense: debugging and understanding payload properties

Setting Date Filter Members to Specific Days of the Week in Sisense Programmatically

Line Chart - Customizing a line to various "Dotted" styles

Controlling JAQL Timeout | Linux

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Using Native Javascript Date Calculations To Modify Sisense Date Filters

How to resolve browser freezing issues (page unresponsive) on your dashboards

Show full date format in the pivot or table widget

Creating dynamic hyperlinks on Pivot2 tables without updating the data model

Enable/disable field suggestions in the NLQ (Simple Ask)

Customizing Upper Label (PlotBands) Labels in Sisense Column Chart Widgets for Long Category Labels

Creating a Year-Over-Year Chart in Sisense

Advanced Scripting for Sisense’s Simply Ask NLQ: Adding Currency Symbols to Pivot Tables

Customizing the Offset Size of Selected Categories in Sisense Pie Chart Widgets

Modifying Simply Ask Natural Language Query Generated Widgets with Scripting

Replace Values with Text - Pivot Table Widget

Resolving resize widget Issue when the Tabber Widget is in use

Limiting Date Range Filters in Sisense Dashboards

Changing Measures In The Entire Dashboard Using Blox User Interface

Plugin - customLogoLink

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense