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: *...
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...
Adding Custom Fonts to BloX Widgets Introduction BloX can import custom fonts to allow more design customization of the widget. A single or multiple custom fonts can be used in a widget. This article explains the steps to add custom fonts to a B...
Filter BETWEEN two dates in the modelThis article explains how to create a filter to return data between two fields in the model. The following cases will be covered:Show only active contracts on the given date;To show the status of the record on the...
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...
How to Create BloX Custom 'From-To' Filter -- All Dates with “Clear” Button We will create a Blox widget to have date filters with the 'From and To' fields and the button Clear. Actually, this button will add a whole range of dates to the filter. Cr...
BloX: replicating action “send me the report now”This article explains how to develop an action to send a dashboard as a report to the end user. This action replicates the action “Send me the report now”. This action is available only to the dashboar...
Dynamically adjusting column precision in Sisense widgets This article details a script designed to dynamically set the number of decimal places (precision) for specific columns in a Sisense widget. The precision is determined based on the first val...
In certain scenarios, users may need to compare the same metric across two different time periods. Here are some example use cases: Sales velocity: Comparing average daily sales for the last 30 days vs. the last 90 days to identify if recent promotio...
Customizing the size of a Blox pop-up using a script on LinuxIntroductionThis article provides a step-by-step guide on adjusting the size of a Blox pop-up using a script applicable to all modals in Blox. This customization can enhance the appearance ...
Exploring RAG: A Sisense-Based Approach with BigQuery and Gemini Continuing from our previous article, Automated Machine Learning with Sisense Fusion: A Practical Guide, where we discussed how Sisense and AutoML simplify complex machine learning wor...
Pivot and Table Widget Scripting for Replacing Values with Colored Arrows Sisense table and pivot widgets offer extensive customization options for data presentation, allowing developers to tailor widget content to specific needs, as discuss...
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...
QuestionHow to show the values selected in the dashboard filter as a Blox widget?AnswerOur example uses a filter/field called "Divison_name".First, in your BloX widget's Editor tab:1. Set "showCarousel" to "true", but add the following option to make...
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...
Question I want to use the Date picker for filtering, however, the dates selected are not getting preserved by the date picker and might be confusing for the end users whether the date is selected or not. Answer You can use the script to keep the ...
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 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...
Input Parameters using BloX for What-If AnalysisThis is an alternative to the paid or community Input Parameter plugins.This new BloX Input Parameter custom action:supports multiple levers (input parameters) with just one Apply buttonsupports all wid...
Blox with drop-down and All values in it Sometimes we need to have an All values option for our dropdown menu in the BLOX. Especially if we just open the dashboard and filter set to Include all. To create it, press the pencil icon to edit the wid...
