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...
Disabling the "Custom Filter" Feature for End-Users This article provides a solution for administrators who wish to disable the "Custom Filter" feature in their applications to prevent confusion among end-users. Instructions The "Custom Filter" feat...
Quickly Add Unique Identifier to Blox Action Buttons Without Modifying Blox Template A customer recently had the unusual request for a method to select and distinguish, via a CSS selector used within a custom Javascript action, for specific Blox but...
Stack 100 Bar Chart - How to Add Percentage of Total (Contribution) to Value Labels This article provides an example solution on how to add a percentage of the total (Contribution) to the data labels in the stack 100 bar chart. How to use it? Open...
Question How to Calculate YTD by Month in a Pivot Table? Answer If you want to show YTD by Month next to your monthly amount you can utilize the "Running Sum" Quick Calculation. If you want to show this next to the monthly amount, just bring in th...
How to Customize Pie/Bar/Column/Area/Line Chart Data Labels If you find yourself needing to modify data labels on a widget, and the built-in capabilities do not allow you to achieve your goal, it might be possible to customize those values with the ...
Expanding on Using Native Javascript Date Calculations To Modify Sisense Date Filters Sisense offers native support for various types of date filter functionalities and also allows users to create and modify dynamic filters entirely using dashboard...
