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