How to Calculate Absolute Sum We have a table with data and we are going to calculate the absolute SUM for [sum] column. We divide this into two parts. First of all, we SUM all positive values with the formula ([Total sum],[sum1]) Th...
How to properly enable/disable plugins on the Sisense guideThe reason we have created this guide would be to increase the awareness of our customers on how to properly enable/disable plugins at Sisense to ensure that you are doing it properly to avoi...
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,...
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 ...
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...
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...
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...
User Parameters Use Case - Automatic Currency ConversionThis article explains one of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cases).In addition to connection settings, Use...
User Parameters Use Case - Automatic Time Zone Conversion This article explains one of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cases). In addition to connection settings,...
Question: How to see the latest date in the Pivot? Solution: You need to change the date to an integer. Then I used the script in the comments in a previous post, and was able to request results. This is the script we used var m_names = new Arra...
How to change the color of the links in the Text widget?To change the color of the link, please do the following.Press 3 dots on the Text widget - Edit Script, paste next script, and press the Save button:const customStyle = { color: 'red' }; wi...
Rules To Live By When Designing An Elasticube A list of recommendations which should be considered when developing an elasticube. Start Small Build your ElastiCube incrementally. Start with only two tables, create an appropriate relationship betw...
Symptoms Sometimes with a pivot table full of many columns with zero and only a few non-zero values, you want the zeroes to display as empty-string. That way the nonzero values really stand out. (This is the opposite of this: Solved: nulls to 0 in...
How to Hide Export to Excel Option On a Pivot Table (Linux) This article provides an example of a code snippet that could be used to hide a specific option from the Download menu on a widget level. If you find yourself needing to hide the export to ...
This article describes how the append dashboard filters as URL params to apply scope automatically to embedded dashboards. The example below shows how to apply members as filters. If you already have dashboard filters defined, you can write the f...
As Sisense currently supports daily data, in the following article we will demonstrate how to include time in Sisense Web widgets that is present in DateTime fields. In order to display time format along with date we would Represent DateTime field ...
An overview of Sisense Linux microservices and what they doThis article provides an advanced description of Sisense’s Microservices and how they work internally. This is mainly for Administrators responsible for supporting Sisense in their organizati...
What is Branding?Branding or white-labeling is a way to alter the visual part of an application to match your application's visual style. Sisense provides a list of options for rebranding the visual style of GUI, emails, and so on.Sisense provides th...
Using HTML for Style and Formatting in Pivots Introduction A common use case within Pivot and Table widgets is to display a clickable hyperlink (see: this community post). However, the ability to render HTML within these widgets can be used for mor...
