Assaf Fraindlich

Total activity 96
Last activity April 12, 2019 11:38
Member since September 12, 2017 09:03

Following 0 users
Followed by 1 user
Votes 29
Subscriptions 37

Activity overview

Latest activity by Assaf Fraindlich

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 attribute 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...
- Assaf Fraindlich
- Edited May 03, 2019 06:32
- 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 snapsho...
- 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
Assaf Fraindlich created an article, August 31, 2018 10:00
Year over Year for the past x months
1. Knowledge Base
2. Dashboard Design
Analytical Need Sometimes we wish to see how we are performing in the last x months and comparing that to the previous parallel period. For example, we wish to see how we perform from Sep last ye...
- Assaf Fraindlich
- Edited August 31, 2018 10:39
- 3 followers
- 0 comments
- 5 votes
Assaf Fraindlich created an article, July 26, 2018 11:28
Calculate Running Sum
1. Knowledge Base
2. Elasticube Data Management
Analytical Need There are cases where you wish to know for a certain point in time, how much you have accumulated up until now. This is called Running Sum. Although it is possible to use this in ...
- Assaf Fraindlich
- Edited September 02, 2018 11:44
- 4 followers
- 0 comments
- -1 votes
Assaf Fraindlich commented, May 21, 2018 09:22
Hi Christopher, You can use the strparts() function. It will regard the json field as an array. Syntax : strparts(fieldName,delimiter, index) delimiter - can be a comma, semicolon, \n etc index -...
- View comment
- Assaf Fraindlich
- Edited October 05, 2018 06:48
- 1 vote