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 DashboardSometimes 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 imported ...
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/...
One of the requests that have come up is the ability to show percentages on a tree map without needing to hover over the widget with a tooltip.The following code overwrites the 'name' displayed with 'name' + percentage to three decimal places:The pe...
Visualization ChallengeUnderstand the rank of each category by total or total contribution in stacked visualizations.SolutionEdit the order of stacked bar or area charts by the total sum of each category.Viz ExamplesWidget without order assigned to c...
How to Change the Pivot Header Row Style with TransformPivot This solution is based on Pivot 2.0 API supported in Sisense version L8.2.1 or later (not supported in Sisense for Windows). For this solution, we shall use cellStyle from Pivot 2.0 API. T...
This widget script will add a gradient to the widget's area spline charts.Configure opacity and RGBA colors as per comments.widget.on('processresult', function(a,b){ // Set colors for the gradient in the "stops" section below. // The top color...
Download: Filter Drill DownIntroduction We will introduce how to filter, drill down fields on a widget basis. Steps: Step 1:Download the attached plugin and place in .../PrismWeb/plugins, if plugins folder does not exist please create it. If you are ...
The 'drill-into' function on the widgets will add the recently used fields (from the datasource fields and not the hierarchical members) on the context menu of the widget which may distract the users who are using it.When there are hierarchies enable...
Currently, in Linux installation, you can face widget [Pivot2]. This is a new realization of the widget [Pivot]. This means that it has new styles, new classes, etc. Almost all the scripts to change styles of the resulting table used DOM selectors to...
Introduction With the Python script below and the Window Scheduler, you can automate the download of csv files based on queries of the SQL API to the elasticube. This type of process comes in handy when a user needs to download information regularly...
Introduction This article explains how to set up a jump to dashboard popup window with a dynamic elasticube Steps Install the Dynamic Elasticube pluginInstall the Jump To Dashboard pluginAdd the following script to the target dashboard script: va...
How to configure Report Manager to send reports to SFTP server using privateKey In this article, we'll discuss how we can configure Report Manager premium add-on to send generated reports to an SFTP server using a private key. SFTP servers allow...
Clean cached RAM This article will discuss how to clean cached RAM on a Linux system. We’ll see how to carry out the clean-up process manually. We’ll make use of tools such as Grafana and echo. Linux is borrowing unused memory for disk caching. Thi...
