In order to sort both axes in the Scatter chart you might need to use the following script under the "Widget Script" levelvar xOrder = 'asc' //also, this value can be desc var yOrder = 'asc' widget.on('beforeviewloaded', function(scope, args) { ...
Use case: Capturing what the end-user has selected to filter. Then writing back the filtered selection to the app mongodb for further analysis of customer dashboard interaction.Instructions: Add the code below as a dashboard script.Notes: Current scr...
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...
“Production line” Status Indicators - Dynamic BloX Widget Introduction This article explains how to set up and use an example Blox widget that creates a dynamic visual representation of a "production line". This widget was developed for a manuf...
Conditional formatting of background colors in pivot tables is one of the best ways to draw attention to numbers, but still provide a clean visual. The use of data bars creates a lot of visual noise, whereas background colors are subtle and act more...
Requirement In this article, we will look to create a personalized dashboard navigation landing page that shows: The logged user's most popular dashboards.Most popular dashboards on the company level. Consider further enhancing the logic present...
One common reason your dashboards may not be working as intended is that your ElastiCube builds are not designed properly. This isn’t a catch-all problem, and though there are multiple reasons why it can occur, the outcome is the same: insights aren...
On article Uploading Files Locally Using Rest (Linux) we saw examples of how to automate the upload of files to File Management. This article describe methods to automate the management of files on File Manager. Compatible with Linux Version <= L...
You can refer to the following article: https://community.sisense.com/t5/knowledge/creating-from-to-date-using-blox/ta-p/771 which already does have a working solution on how to create a date filter with BloX widget, however 100% of customers are exp...
Download using the attachment below Introduction A common requirement when performing grouping and aggregate operations, is to include all dimension values in the group irrespective of the contextual filters applied on the transaction table. ...
ProblemAdvanced formulas can sometimes return wrong results (or no results at all) when combining dimension-affiliated calculations** with dashboard or widget filters based on a second dimension.Certain calculations may include backstage joins betwe...
Leveraging Usage Analytics for Determining Heavy Widgets In this article, we can find a suggested approach on how to determine dashboard widgets that consume a lot of memory and may cause performance issues. Usage Analytics Usage Analytics is part ...
The following solution is relevant to both Pi and column charts. Illustrations were supplied for Pi charts only for simplicity. If you'd like to remove the percentage value in the tooltip hover menu as illustrated below:For Pie charts:Edit widgetEdit...
This article explains how you can embed images from an external drive (Google Drive) to the Sisense widget. Note: The solution is implemented with the help of the Blox plugin and on the L2023.3 Sisense version. In order to embed an image into the Blo...
How to troubleshoot the "Widget Type: Blox is Not Registered" Error and Similar IssuesWhen you see an error on a widget level saying that a specific widget type is not registered (as on the screenshots below (for example, Blox or Table with Aggregat...
Download: Center Zero Intersect Introduction This article explains how to center the zero intersect of a bar chart. This can be done manually be setting the axis min/max, but this solution provides a way to do this dynamically.StepsSTEP 1 - ADD THE ...
Unexpected Behavior When Trying to Share a Dashboard Sometimes you can face unexpected behaviors of the system when a dashboard is rendering data,l but you as owner are not able to republish it with other users. Case #1 If this dashboard was im...
The widget script below can be used to change the opacity of scatter chart markers, either for specific series (colors) or for the entire chart (Last Tested on 7.1.1.10089).//Series you want to adjust. Leaving this array empty will adjust all series ...
50,000 Row Limit in Live Model export to CSV This article gives detailed steps on how to overcome the 50,000-row limit in Live Model export to a CSV file. When downloading data from a Sisense Dashboard, based on a Live Model, into a CSV format, Sis...
Reverse Proxy with Nginx + SSL configurationNginx Reverse proxy configurationStep 1. Nginx reverse proxy server set up In this example, we are using nginx, we can install it on the same device as Sisense. To install it run1. Install nginx for Ubuntu/...
