David Hertzberg

1. Community
2. Dashboard Design
3. left join on date dimension

Hi Lisa, I may be wrong, but it looks like you will have to change your fact table into a custom sql table that will do a union between original fact table and rows you will add so that the fact t...

• View comment
• David Hertzberg
• Created November 24, 2019 23:04
• 0 votes

1. Community
2. Elasticube Data Management
3. Weekly Targets and Monthly performance

Hi, I would not recommend mixing weekly and monthly figures as you can have weird configuration in some scenarios at the begining or end of the month with partial weeks. If you work with weeks and...

• View comment
• David Hertzberg
• Created November 24, 2019 22:53
• 0 votes

1. Community
2. Dashboard Design
3. Latest Date

Hi Inbal,   Your article seems to be really interesting, unfortunately, the link seems to be broken and your profile page in the support platform does not include this article. Can you republish it...

• View comment
• David Hertzberg
• Created November 19, 2019 13:10
• 0 votes

1. Community
2. Dashboard Design
3. Widget Title

Hi, you can also add your images as BloX widgets : there is an option to remove the title zone. I guss you can also do the same with javascript. Best, David.

• View comment
• David Hertzberg
• Created November 01, 2019 10:53
• 0 votes

1. Community
2. Dashboard Design
3. Add spacer blocks to dashboard

If you want to go deeper in dashboard design and user experience, you should check BloX (from Sisense Marketplace)  => you will get a lot of possibilities   Best, David.

• View comment
• David Hertzberg
• Created November 01, 2019 10:52
• 0 votes

1. Community
2. Dashboard Design
3. column chart for closed tickets

Hi Akondi, I guess you need the number of opened tickets, then you can add a formula like COUNT(Closed Tickets) / COUNT(Opened Tickets). Depending on our data structure, you can then add filters/sp...

• View comment
• David Hertzberg
• Created November 01, 2019 10:49
• 0 votes

1. Community
2. Data Connectors
3. Excel Missing from Available Connectors

Hi, You probably got the answer, but just in case it still happens, usually this is linked to a Sisense service that has stopped. Just look at Sisense services in task manager, and restart the one ...

• View comment
• David Hertzberg
• Created September 17, 2019 12:54
• 0 votes

1. Community
2. Dashboard Design
3. Displaying row in table even when one of rows is missing.

Great. The article you refer is very interesting. If you want something simpler, you can start with trying the trick with the count agregation. When it works, it shows 0 for the dimension that has ...

• View comment
• David Hertzberg
• Created September 05, 2019 12:04
• 0 votes

1. Community
2. REST API
3. Getting dashboard data via API

Hi Vikas, You can do that, but not with only one API call. You can also do it through queries in the MongoDB. It will be closer to a script than just one query though. Best, David.

• View comment
• David Hertzberg
• Created September 05, 2019 10:34
• 0 votes

1. Community
2. Elasticube Data Management
3. Delete rows from an accumulated table

Unfortunately there are no possibilities, except relaunching a full build (with a proper time filter in your import script). Most of the cube I use, I schedule a full refresh from time to time, or ...

• View comment
• David Hertzberg
• Created September 05, 2019 10:24
• 0 votes