An offline, or air-gapped, Sisense environment provides higher security than online, connected environments. As the offline environment has no outside communication, the only method to install Sisense in this environment is by using removable media,...
How to dynamically change the color of the bar chart The Question... How do I dynamically change the color of my bar chart (as if it wasbreak-by)? My goal is to have the color of the bar of each category match the color of the line in the line chart...
Adding additional dimensions to the Scatter Map widget tooltip Additional dimensions can be added to the hover tooltip of the Scatter Map widget type, beyond the default limit of three, to include more information from other dimensions about a locati...
Question: I have requirement to combine and show the dimension. There are two dimensions Product and Product_Family. I want to display it as single dimension in charts like "Product 1 | Product Family 1", "Product 2 | Product Family 1", so on.Solutio...
Analytical Need You want to display a value for a selected member (i.e. Salesperson) vs the min/max of all non-selected members. This can be achieved using modeling techniques but this solutions describes how to do it purely in the front end. Soluti...
Hide the widget's Button from the Toolbar for Viewer User We will be learning how to hide information/additional buttons on the widgets from the Viewer user. Also, it is possible to hide these buttons from all users. For this press the 3 dots ...
Question: How can I find the exact version and build of my Sisense environment? Solution: There are 3 easy ways to find the exact version of your environment: On the web application Open your Sisense web applicationOn the top toolbar, click on t...
Analytical Need Sometimes we wish to see how we are performing in the last x months and comparing that to the previous parallel period. For example, we wish to see how we perform from Sep last year to Aug this year and compare it with Sep 2 years ...
This article demonstrates two methods to count the number of days that passed from one event to the other for a specific category (i.e number of days passed between one sale to another by sale code). The preferred way to do this calculation is in a c...
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...
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...
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...
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...
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...
Analytical NeedThis dimension table keeps every change that has been made. The user wishes to see historical data per the dimension and not just the current state.Example: Transactions per organizational hierarchies, price list, historical currency ...
Analytical Need A common requirement in data analysis is to be able select values from several filters and to see the results that contains all of those values and not only the results where only selected values appear. In fact, the requirement is...
If you are using a gauge indicator in your dashboard and want to make the gauge reflect a percentage like shown below (elasticube is Sample Retail) - Follow the steps below - Steps:1. Create an indicator widget and add a value you want to review. In ...
Some steps in the Sisense support documentation vary depending on whether the Sisense instance you are working with is running on Windows or Linux.These steps are how you can check:Log into your Sisense instanceClick on the person icon in the top rig...
If you are interested in how Sisense support working with ticket, this article is for you. Beforehand we recommend checking the following links: Getting Started with SisenseSigning in to Sisense Support PortalGuideline for submitting a Support inq...
How do I sign in? To access the Support Portal, you must first register for a Sisense Community account. Please ensure you use the same business email we normally correspond with as emails must match our contact management system to link your Commun...
