Analytical Need In certain scenarios, one would like to show an indicator that presents the ranking of a current selection(filter) out of all the items in the pool. This allows the viewer to quickly understand how well a particular selection is per...
Analytical Need Often times, we are required to present all the existing records in our dimension whether we have or don't have records to aggregate for it from our fact table or simply, perform a left join on-demand instead of the by-product inner...
Analytical Need Send Pulse notification only by the end of the month to track monthly performance.Cube is being built daily. Modeling Challenge Sisense will trigger Pulse alert after every cube build if the condition is met. If the cube is being b...
Description Creating a sorted label for the week days or months (names) in a widget is not a simple task. The base sorting is based on alphabetical order and not on the logical order of days or months. For example (Issue) : Friday Monday Saturday S...
Analytical Need Calculate the pivot grand total at the row level to do calculations such as % of the grand total. You may have tried the following and not received the desired results: ALL function This will ignore your row groupings, which is what...
Month to Date (MTD) and Year to Date (YTD) calculations provide us results of activity in the time between the beginning of a date (can be a month or year in our example) and the beginning of the current month or year. This in turn allows data analy...
Sometimes we'd like to see all our data up to today, not including. It is very easy to achieve this within the Elasticube by creating a custom column which calculates the daydiff between the date to today i.e. daydiff(now(),[date_field]) and then fi...
This article will show how to set conditional formatting on a specific value based on another one that doesn’t directly relate to it. For example, when one wants to show a total of revenue in a specific region and set its color to green in case the ...
Question: How can I transfer Sys.Admin role to another user? Prerequisites: Login credentials for the current sys admin (if these are unavailable, please contact Sisense Support to explore further options) Relevant Background Information: There mus...
Question: How to change the activation period for new users Purpose/Benefits For security purposes, new users have a seven day activation period. After that seven day period they no longer can activate their account. The following steps will e...
Question: I have a mobile application that will have a link to a Sisense dashboard. Rather than opening the link in a browser, I am hoping to have the link open in the Sisense native application. How can this be done? Answer: This can be done wit...
How do I connect to Active Directory?Go to Active Directory under Admin in Sisense webConnection String : the address to the Active Directory server (ask your IT department)Base DN: Break down your domain and include all hosts. before each word in ...
Question: Many customers have expressed interest in disabling the emails that Sisense sends to users when certain events occur, such as a user is added to Sisense or a user is shared on a dashboard. For a list of these emails and more information...
Sisense has two aspects of license and user management for activating the system and accessing Sisense platform. This article demonstrates how to handle password update for either Sisense Package Activation or Sisense Web Application access. Authenti...
In the past, the Postgres vs. MongoDB debate looked like this: you had Postgres on one side, able to handle SQL (and later NoSQL) data, but not JSON. On the other, you had purpose-built database management systems (DBMS) — like MongoDB, which was de...
The promise of Postgres JSON JSON support is the most interesting new Postgres feature of the last few years. It relaxes the primary constraint of SQL databases — the rigid schema structure — by letting you store semi-structured data in your tables ...
