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

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

Performing An Aggregate Product In Sisense

Purpose: To create a product aggregation in Sisense (multiplies all values together, similar to the way a sum function adds all values together). Situation: A financial use case has a table with relative daily gains/losses for certain securities (thi...

Community_Admin_0-1634209558417.png Community_Admin_1-1634209558452.png Community_Admin_2-1634209558416.png Community_Admin_3-1634209558464.png

Create Widgets With Month Or Day Names By The Correct Order

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

Community_Admin_0-1634207198710.png Community_Admin_1-1634207198754.png Community_Admin_2-1634207198770.png Community_Admin_3-1634207198737.png

Show last month with data

The last month with data isn't the current calendar month (payroll for instance).The out of the box feature of Sisense supports only the last calendar month Below shows a solution to have a default filter that shows the most updated month with data. ...

Community_Admin_0-1634206648977.png Community_Admin_1-1634206648974.png Community_Admin_2-1634206649104.png Community_Admin_3-1634206648976.png

Limit Dashboard Filter Items By Another Filter

At times, you might want to limit the items suggested in a dashboard filter by another field's value (for example: enable the user to choose between all subcategories under a specific Product Category). This functionality can be achieved using a depe...

Community_Admin_0-1634206467047.png Community_Admin_1-1634206467205.png Community_Admin_2-1634206467068.png
Labels
Community Toolbox

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

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy