Sometimes we'd like to define variables to hold specific metrics and use them throughout the dashboard in several places, with the ability to change / control them in one repository without the need to manually change each formula or widget. A good ...
Introduction: By using the re-branding API you can replace the default homepage with a specific dashboard. (For further explanation of the branding functionality please read this article.) Keep in mind you need to leave only what you change ("string...
If you need to color columns in a column chart based on a different formula you will need to use the following solution. For this example, we will color the columns that calculate [Total Cost] for the [City] by another value, that is calculated by t...
This page is intended to keep a focus on Dashboard design in terms of: Planning Implementation User experience and functionalityDashboard training for end users Dashboard Planning Dashboard planning goes hand in hand with project planning, and will ...
Issue In Survey Data you might have 10th or even 100ds of parameters per questionnaire, Sisense suggest transposing all the parameter into one column (See article). Once you do that you might run into an issue filtering questionnaires that answered ...
This post will show how to create an easy to use Radiobutton filter (single selection type) with a list of predefined custom time frames. The created time frames can also be used for breaking by charts or pivots, providing a visual comparison betwee...
This article explains how to automatically switch between dashboards every predetermined amount of time. This might come useful, when you have multiple dashboards that you want to be presented in a cycle on a monitor to reflect updated data\records....
Analytical Need For a metric, I need to calculate the month difference between the min and max date of purchase for each brand in my dataset. I want the dates to be dynamic in respect to filtering, etc. I am using the attached .ecdata and .dash fi...
Question Is there any way to get the views to execute sequentially instead of simultaneously? How does the dashboard in Sisense execute the queries? Answer The Sisense client application does attempt to send out all queries (one per widget) at onc...
Question: How to see the latest date in the Pivot? Answer: You need to change the date to an integer. Then I used the script in the comments in a previous post, and was able to request results. This is the script we used var m_names = new Array("J...
Question: I'm attempting to select the First Time (day) each product in a list was ordered. Example:Product A | 10/10/2018Product A | 10/30/2018Product B | 09/01/2016Product B | 10/10/2018Result: Product A | 10/10/2018Product B | 09/01/2016 Answer...
Question: I have a list of items that have multiple date-oriented entries. I have a numerical field that indicates days since last scan, so I can filter based on the lowest number of days per item. What I am trying to do is count the number of items...
Question: I have created a custom starred filter, however, when i go to a different account that is not the admin, this does not appear on the date filter. Answer: Designers should be able to view starred filters when dashboards are republished, b...
Question: I'm looking for a way to count number of records below and above median/AVG. Answer: Step 1: Add all category columns (Country, City, ID) to the Rows panel.Step 2: Add a column under the Value panel that calculates the total amount. The ...
Question: When 2 people can design 1 widget and work on it one by one, system doesn't sync the changes. Answer: Whenever a dashboard is created in Sisense, the user who created it is it's owner. Only one user can be the owner of a particular dashb...
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...
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...
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 ...
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...
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, ...
