Hendrik Venter

1. Community
2. JavaScript API
3. Replace Null values or N/A's with zeros in Pivot Grid

My requirement is to simply display a 0 in a Indicator widget when no data. " IF(ISNULL(SUM(value)) = true, 0, SUM(value)). " doesn't work Got this formula to work in the end: IF(ISNULL(SUM(value))...

• View comment
• Hendrik Venter
• Edited July 30, 2019 05:40
• 1 vote

1. Community
2. JavaScript API
3. Popup widget on click with filtering

Assuming this doesn't work with later versions of Sisense anymore (v7.3). I tried implementing it but the drill event doens't work. Looked like a good solution - Ah well

• View comment
• Hendrik Venter
• Created July 10, 2019 04:54
• 0 votes

1. Community
2. Dashboard Design
3. “Data Last Updated On Date” Widget

Hi Michael Thanks for the quick reply. We use Sisense Embedded and hide all toolbars from the end-user - so they don't see the top bar with last refresh date. We've had mountains of issues with wid...

• View comment
• Hendrik Venter
• Edited July 05, 2019 05:37
• 0 votes

1. Community
2. Dashboard Design
3. “Data Last Updated On Date” Widget

Also, is there a way to display the date format in the correct format of DD/MM/YYYY? (Days / Months / Years). 

• View comment
• Hendrik Venter
• Created July 05, 2019 05:20
• 0 votes

1. Community
2. Dashboard Design
3. “Data Last Updated On Date” Widget

Is there any way to get the TIME component to display as well? This is very useful in cases where there is multiple cube builds per day Unfortunately it doesn't seem Sisense supports DateTime (Date...

• View comment
• Hendrik Venter
• Created July 05, 2019 04:32
• 0 votes

1. Community
2. Plugins
3. Wiser Filter Widget

Found this filter extremely useful (and I'm surprised Sisense hasn't officially created one)! However, ran into a bug. When there is only 1 item in the select list, it won't select but default back...

• View comment
• Hendrik Venter
• Edited July 04, 2019 02:13
• 0 votes

1. Community
2. Dashboard Design
3. "Only top 10 records"

Is it possible to only show the top 10 records based on the sorting of a pivot/table? The current method forces you to select a "Top x BY yyy" which means yyy in this case will provide incorrect re...

• View comment
• Hendrik Venter
• Created June 27, 2019 00:15
• 0 votes

1. Community
2. Dashboard Design
3. Getting records based on latest DATETIME

Hi Hamza Thanks for the reply and suggestion. I've tried the RANK() function however it seems incompatible with datetime values. I get an error "Error in function definition: Expecting parameter of...

• View comment
• Hendrik Venter
• Created May 27, 2019 23:03
• 0 votes

1. Community
2. Plugins
3. Hide Widget Titles

Hi Danielle You're correct, as Viewer its hidden. Its a bit different behaviour than "hideTitles" plugin we're using for other widgets. Thanks for the helpHendrik

• View comment
• Hendrik Venter
• Created May 26, 2019 21:48
• 0 votes