Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

How Can I Replace A Dashboard By ID?

Question: I have a dashboard that is referred to via a static Web page. I've developed a replacement dashboard but I want it to have the same exact object id number as its predecessor. So, I want to overwrite a dashboard ID with a completely differe...

Custom Date Filter "Since"

Question: I am looking for a solution to filter my data based on time period. I currently have data going back to 2016, but I want to filter it to show only entries for 04/2019 until today.  Answer: You can do this with a custom-filter. Add your d...

Filter Field Where Value Contain Word

Question: Is there any kind of way that allows me to filter a field based on "contains word" criteria. Answer: You can set such a thing as a filter on a dashboard, widget, or formula on any dashboard JAQL syntax { "contains": "mm" } You can also ...

Community_Admin_0-1634254107775.png Community_Admin_1-1634254164824.png

How to Filter A Formula By A Number

Question: Currently, when creating a formula at the widget level, you can filter the formula but by a text field only. How can I filter the formula by the numeric field?  For example, this is helpful when creating a percent of total calculation -- I...

Community_Admin_0-1634253893532.png

Calculate non unique values

Question: I have an example of data below. I want to be able to get a count of the Unique Member ID's that have more than 1 different confirmation number tied to it. So in the simple example below that number would be 1. Member 55555 has 3 entries, ...

Community_Admin_1-1634253389517.png

Use Date Inside Pivot Value Cell

Question: How can I use the date in the Pivot values? Answer: You can follow these steps: 1. Convert the date into an Integer with this chunk of SQL: GETYEAR([Date])*10000 +GETMONTH([Date])*100 +GETDAY([Date])   2. After you have an Integer repre...

How to send emails to Gmail groups

Question: I am trying to send scheduled reports to Gmail groups. Is it a possible option if so how can this be achieved?  Answer: Email recipients must have a user account in Sisense in order to receive dashboard emails. There are a few possibl...

Resizing SVI (System Volume Information)

Question: Sometimes your server might run out of space on because the SVI (System Volume Information) is eating up all memory.   The system volume information is used in windows in order to save information related to system restore which is used wh...

Current Rank out of Total Indicator

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...

Community_Admin_0-1634216022605.png Community_Admin_1-1634216022535.png Community_Admin_2-1634216022485.png Community_Admin_3-1634216022573.png

Send Pulse Notification Only By The End Of The Month

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...

Calculate Pivot Total at Row Level

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...

Community_Admin_0-1634205398347.png Community_Admin_1-1634205398519.png Community_Admin_3-1634205398745.png Community_Admin_4-1634205398743.png

Exclude 'today' using jaql

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...

Community_Admin_0-1634204497801.png Community_Admin_1-1634204543065.png

How to Transfer Sys.Admin Role Across Emails

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...

Screen Shot 2022-08-08 at 9.24.51 AM.png Community_Admin_0-1634177968694.png

Change the User Activation Expiration Period

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...

Labels