Assaf Fraindlich

Total activity 104
Last activity November 06, 2019 14:58
Member since September 12, 2017 09:03

Following 0 users
Followed by 1 user
Votes 32
Subscriptions 39

Activity overview

Latest activity by Assaf Fraindlich

Assaf Fraindlich commented, November 06, 2019 07:32
Official comment
If you're not seeing the option then (with default JTD settings) you probably don't have a dashboard that begins with _drill that is based on the same cube. Verify that you have such a dashboard. I...
- View comment
- Assaf Fraindlich
- Edited November 06, 2019 14:58
- 1 vote
Assaf Fraindlich created an article, September 05, 2019 07:39
Calculate QTD (Quarter to date) flag
1. Knowledge Base
2. Data Modeling
This is the solution of how to calculate the QTD, in continuation of the article : Calculate MTD, QTD and YTD Values If the dim date is a base table you'll need to add the following 3 invisible fie...
- Assaf Fraindlich
- Edited September 05, 2019 07:43
- 1 follower
- 0 comments
- 3 votes
Assaf Fraindlich commented, July 17, 2019 16:34
It also works from text widgets
- View comment
- Assaf Fraindlich
- Created July 17, 2019 16:34
- 0 votes
Assaf Fraindlich commented, April 12, 2019 11:37
For versions 7.2 & up you will need to remove the same file as in Andrew's 1st comment, but please use the following location : C:\Program Files\Sisense\app\client\views\home
- View comment
- Assaf Fraindlich
- Edited April 12, 2019 11:38
- 0 votes
Assaf Fraindlich created an article, March 27, 2019 10:59
AND filter - How to identify Items that have all selected values
1. Knowledge Base
2. Dashboard Design
Analytical Need I would like to count all the products that are sold in Germany & Canada. When you select Germany and Canada in a typical Sisense filter, it will give you results for products tha...
- Assaf Fraindlich
- Edited November 20, 2019 12:21
- 1 follower
- 0 comments
- 2 votes
Assaf Fraindlich commented, March 26, 2019 11:55
Hi Hendrik, Link has been fixed.
- View comment
- Assaf Fraindlich
- Created March 26, 2019 11:55
- 0 votes
Assaf Fraindlich commented, March 25, 2019 11:37
Hi Piotr, Try this piece of code (might need some tweaking with the xAxis or yAxis): widget.on('beforeviewloaded',function(w,ev){ ev.options.xAxis.plotBands= [{ color: '#72D15D', ...
- View comment
- Assaf Fraindlich
- Created March 25, 2019 11:37
- 0 votes
Assaf Fraindlich commented, March 08, 2019 08:43
Article updated to support V7.X and above
- View comment
- Assaf Fraindlich
- Created March 08, 2019 08:43
- 0 votes
Assaf Fraindlich created an article, October 02, 2018 11:51
Add File Name & Created Date to Excel/csv File
1. Knowledge Base
2. Elasticube Data Management
Analytical Need In many cases we need to use the metadata of the file name & the created date of a file as a filter/dimension in the dashboard. For instance, use the created date as a snapshot da...
- Assaf Fraindlich
- Edited November 07, 2018 10:52
- 1 follower
- 0 comments
- 1 vote
Assaf Fraindlich created an article, September 20, 2018 08:40
Build A Flattened Hierarchy From 2 Levels
1. Knowledge Base
2. Data Modeling
Analytical Need In many cases a hierarchy appears in the data structured as 2 levels - A parent and a child. The business user would like to see the entire hierarchy and analyze the data according...
- Assaf Fraindlich
- Edited September 20, 2018 08:45
- 2 followers
- 0 comments
- 4 votes