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

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

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

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

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

Sisense Compose SDK

Sisense Compose SDKThe Future is ComposableIn the fast-paced world of data-driven applications, developers are constantly seeking innovative ways to create customized data products that seamlessly integrate into their projects. Sisense has stepped up...

Applying Conditional Formatting to Specific Columns in Sisense Pivot2

Applying Conditional Formatting to Specific Columns in Sisense Pivot2 Summary Learn how to make all "Yes" values in a specific column of your Sisense pivot highlighted with a green background. The solution was tested on the L2024.2 Sisense version. ...

Advanced Filter plugin compatible with Latest Sisense versions

Advanced Filter plugin compatible with latest Sisense versions Implementation: --------------- 1. Extract the .zip file into the plugins folder on the Sisense directory (Under Admin -> File Management -> Plugins) 2. Open a Sisense dashboard and cr...

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

Blox - Multi-Select Dropdown List Filter

Blox - Multi-Select Dropdown List FilterThis article will take you step by step on how to create a multi-select dropdown filter using Blox and JavaScript. ElastiCube:1. For each field you want to use in multi-select filter, you need to add a custom c...

Programmatically Formatting Bar Chart Widget Value Labels in Sisense

Programmatically Formatting Bar Chart Widget Value Labels in SisenseThis article outlines ways to programmatically format Sisense Bar Chart Widget Value labels via widget scripts, covering methods to prevent label overlap and apply consistent styling...

How to Check SSL Ciphers

How to Check SSL Ciphers If you have enabled SSL on Sisense side, the Nginx controller will be deployed in the default namespace. To check the currently configured ciphers run the following command and check the "nginx.ingress.kubernetes.io/ssl-cip...

Exploring the Potential of Sisense Jump to Dashboard Filter Configurations

Exploring the Potential of Sisense Jump to Dashboard Filter Configurations Introduction: Sisense Jump to Dashboard offers a powerful way to enhance the user experience and streamline data exploration with the help of different filter configurations....

Using the InternalHttp Function Within Scripts and Plugins

Using the InternalHttp Function Within Scripts and Plugins The InternalHttp function is a Sisense function within the Sisense internal Prism object. The prism object and the InternalHttp function are present on all Sisense pages and can be used in sc...

Financial Formatting for Pivot Tables on Linux

QuestionHow to apply Financial Formatting to Pivot Tables?AnswerFinancial reports usually have specific styling requirements where negative numbers are shown in parentheses as opposed to having a leading minus sign. They are also usually written in r...

Interactive Time Period Comparison with BloX & Custom Actions

Interactive Time Period Comparison with BloX & Custom ActionsHere is a use case on how to leverage BloX widgets in Sisense to create an interactive dashboard for comparing any KPI between two different periods. This solution allows users to select tw...

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

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

Using Native Javascript Date Calculations To Modify Sisense Date Filters

Creating dynamic hyperlinks on Pivot2 tables without updating the data model

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

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

Sisense Compose SDK

Applying Conditional Formatting to Specific Columns in Sisense Pivot2

Advanced Filter plugin compatible with Latest Sisense versions

Limiting Date Range Filters in Sisense Dashboards

Changing Measures In The Entire Dashboard Using Blox User Interface

Blox - Multi-Select Dropdown List Filter

Programmatically Formatting Bar Chart Widget Value Labels in Sisense

How to Check SSL Ciphers

Exploring the Potential of Sisense Jump to Dashboard Filter Configurations

Using the InternalHttp Function Within Scripts and Plugins

Financial Formatting for Pivot Tables on Linux

Interactive Time Period Comparison with BloX & Custom Actions

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