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...
Network Error: Pending Operation: Update Model Layout You receive the following alert: Add data Network error: Response not successful: Received status code 400 Pending operation: Update model layout during the process of updating the table quer...
Fixing the File Manager When It's Not Working for Tenant Admins Despite the "File Manager" being enabled in the "Feature Management" menu and working properly for the System tenant admins, the tenant admins receive the "Access Forbidden" error on th...
Resolving Issues with Commenting on Tickets on Sisense Portal This article addresses the issue of being unable to type or comment on tickets on the Sisense portal. The problem may manifest as an error message when attempting to type a comment. Follo...
In a custom column, add a prefix number followed by a period and a space to the dimensions you want to sort in pivot.For example, if we have a column called Category with the following categories:First CategoryAnother CategoryCreate a custom column c...
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...
Show the Data for This and Last Year, But Not the Current Month Dynamically Task: We want to show data for this and last year, but not the current month dynamically. For example, we have this data: We want to show it, but not for the current month,...
This article details the process of creating a BloX button that applies/removes Break By on one or more widgets. Step 1Create the widget(s) including the Break By field. We will need to retrieve the JAQL for the Break By field and add it later via a ...
Changing your UID and GID to 1000While deploying Sisense on a Linux OS Distribution, you may need to use UID and GID 1000 for the installation user (linux_user in YAML). Step 1: Check the UID and GID of your installation user:Run the following comman...
Show in the Pivot Top 7 Values, Starting From the 3rd We have a task to show from the top 10 values just from 3 through 10. Based on Sample Ecommerce elasticube, we have in rows - "Brand" and in values "Total revenue" To see just the Top 10 we will ...
In case when you need to change the owner of multiple dashboards there are few ways: 1) In case all the dashboards are in 1 folder then you can select the folder and export the dashboards. After what, import the dashboards back under the user to who...
SisenseJS silent login approachDisclaimer: Please note that this blog post contains one possible custom workaround solution for users with similar use cases. We cannot guarantee that the custom code solution described in this post will work in every ...
Workaround for "File exceeds Limitation of 500 MB" If you try to import a CSV file to Elasticube and receive a message "File exceeds the limitation of 500 MB" As a workaround, you may upload large .csv files to the File Manager and then point to th...
Explanation of the Report Manager Settings Question Could someone clarify what these settings do and how or if they interact with each other? - reportManager.maximumExportRetries- reportManager.userReportOwnerForNonSisenseUser- "Number of simultaneo...
* Disclaimer: This works for Windows only. It will work in future with Linux versions as well. Once it does, I will update the post. Sometimes, we need to export a table from the Elasticube to a CSV file. We can then import it to the next build, to s...
Introduction when adding numeric dimension to pivot and table widgets in the rows section and not the value section (in cases where the numeric value is an attribute and not a measure) you can change the alignment of the number dimensions to the left...
Solutions to commonly found issues when setting up a new Sisense ComposeSDK project during beta The first two solutions involve issues with installing ComposeSDK dependencies during the beta period while the ComposeSDK dependencies are hosted ...
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...
To embed dashboards from Sisense into your web application, typically you would use either the IFRAME or EmbedSDK approaches (see sisense.dev for more details). If your application is written in React, then React components to achieve tasks, like th...
