In this post you can learn how to automatically 'Restore Dashboard' on each page refresh or opening, this setting will always restore the dashboards initial published state for your viewers and designers. This can be used for cases where you would...
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...
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...
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...
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...
How to Use "OR" Filter Condition on a Widget Level | JavaScript This article provides an example JavaScript code snippet to have the ability to use the "OR" filter condition on a widget level. Currently, the Filter Relations Editor in Sisense allows...
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...
Restoring missing connector Introduction Sometimes connectors can go missing for some reason, leading to a breakdown in data connectivity. Restoring these connectors is crucial to maintaining a smooth data flow within your Sisense environment. This...
Plugin - Custom Coloring of Bar and Column chart-type widgets This plugin modifies the color scheme of bar and column chart-type widgets to match the current color palette of the dashboard. Installation To install this plugin, download and unz...
This article will explain how to create reset to default filters button in BloX This helps in case you want to provide this icon functionality on the dashboard and not just in the Filters panel. Create a new custom action with the below code: *...
Plugin - Disable Link To Sisense Server Homepage In Top Left Logo Icon This plugin disables the link to the home page of the top left logo in the Sisense UI. The plugin also removes the logo icon being treated as a link on mouse hover. This logo im...
Hide the widget's Button from the Toolbar for Viewer UserWe will be learning how to hide information/additional buttons on the widgets from the Viewer user. Also, it is possible to hide these buttons from all users. For this press the 3 dots in the...
Use Case My users and designers were looking for an easy way to get insights into how certain dashboards and widgets were built in terms of formulas and filters. Solution For this, I have written a Python script that takes a list of dashboard IDs...
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...
