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 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. Solution: You can do this with a custom-filter. Add your dat...
Question: How to see the latest date in the Pivot?Solution: 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 usedvar m_names = new Array("Jan",...
Question: I'm attempting to select the First Time (day) each product in a list was ordered. Example: Product A | 10/10/2018 Product A | 10/30/2018 Product B | 09/01/2016 Product B | 10/10/2018 Result: Product A | 10/10/2018 Product B | 09/01/2016Solu...
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'm looking for a way to count number of records below and above median/AVG.Solution: 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 f...
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.Solution: Designers should be able to view starred filters when dashboards are republished, but...
Question: When 2 people can design 1 widget and work on it one by one, system doesn't sync the changes.Solution: 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 dashboa...
Question: I want a Column Chart with 3 metrics- 2 of the metrics are stacked while one remains a single Column. I would even consider doing the 2 metrics stacked and the 3rd as a line, but if I choose 'Stacked' as my Column Chart Type, the ability to...
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: 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 different...
Question: Is there any kind of way that allows me to filter a field based on "contains word" criteria.Solution: You can set such a thing as a filter on a dashboard, widget, or formula on any dashboardJAQL syntax { "contains": "mm" }You can also use '...
Question: How can I use the date in the Pivot values?Solution: 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 representatio...
Recommended quick links to assist you in optimizing your community experience:
Need additional support?:
