Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
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 differen...

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

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

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

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

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

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

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

Dynamic Pivot Table Data Bar Color Formatting

Introduction This article describes how to dynamically color the Data Bars within a pivot table based on the cell values. Presented here are two methods: Use stock gradients to provide different colors based on cell values Define RGB shade magnitudes...

Community_Admin_0-1634215540090.png Community_Admin_1-1634215540145.png Community_Admin_2-1634215540068.png Community_Admin_3-1634215592871.png

Sharing a file from a local machine in a dashboard

Sisense has the capability to share a local file (excel, word, pdf etc.) with dashboard users. Note: The file must be saved on the server in the following path: %programfiles%\Sisense\PrismWeb. You can create a new folder or save it under 'Resources'...

Community_Admin_0-1634214849689.png

Dashboard Performance Best Practices

In this article, we are going to map some of Sisense Dashboard Design Best practices related to performance. When you start developing a dashboard or when you want to simply improve its performance, take a look at the guidelines below and adjust your...

Community_Admin_0-1634214716429.png

Maximize Dashboard Performance

What is good dashboard performance? Dashboard performance is the time it takes to load a Sisense dashboard. We want our users to have a good experience when working with our data. The time taken to load the dashboard is the first step. Each individua...

Community_Admin_0-1634214402091.png Community_Admin_1-1634214402220.png Community_Admin_2-1634214402215.png Community_Admin_3-1634214402088.png

Pareto Analysis

Analytical Need Pareto analysis is a technique based on the Pareto Principle which states that 80 percent of problems or effects are produced by 20 percent of causes. This type of analysis can be useful in the stage of decision making, to identify th...

Community_Admin_2-1634210146655.png Community_Admin_3-1634210146760.png Community_Admin_4-1634210146661.png Community_Admin_5-1634210146674.png

Top 5 + Bottom 5 In The Same Chart

Analytical Need You want to display a chart/table with the Top X and Bottom X, all in the same widget Modeling Challenge Sisense allows setting ranking filters based on a measure, but this is only for Top OR Bottom. Solution Widget Filter: Create you...

Community_Admin_0-1634210018875.png Community_Admin_1-1634210018821.png Community_Admin_2-1634210018800.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 bui...

Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com