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...
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...
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 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 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 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 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 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...
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 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 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 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 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 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...
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 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...
Advanced Pivot Widget Scripting - Combining Custom JAQL and the Pivot 2.0 API While the Pivot Table Widget Type is a highly customizable and flexible Sisense widget for representing data in tabular form, certain use cases may be best achieved through...
Toggle Logarithmic Feature Question I want the user to be able to toggle on and off the "Logarithmic" feature from the design panel. Answer See the script below: widget.on('processresult', function(se, ev){ev.result.chart.spacing = [20, 20, 77, 20...
Demonstrating ComposeSDK Styling Of Existing Sisense Dashboard Widgets When developing ComposeSDK embedded applications, there are three principal techniques for embedding or converting an existing Sisense widget. Discussing each method, and some o...
Converting an Existing Sisense Widget to a Dynamic ComposeSDK Widget Component Using either the widget Sisense API's, or the Sisense widget JS API object, it is possible to determine all components and parameters of a widget required to create an eq...
