Avatar

Hendrik Venter

  • Total activity 38
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 4
  • Subscriptions 8

Activity overview

Latest activity by Hendrik Venter
  • Avatar

    Hendrik Venter commented,

    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))...

  • Avatar

    Hendrik Venter created a post,

    Pivot/Table drill to "Sub Pivot/Table" detail

    (Sisense v7.3) How do I create a "sub-report" concept in Sisense? I'm displaying aggregated data in a pivot / table, and want to enable the user - when clicking on a row in the pivot/table, to dril...

  • Avatar

    Hendrik Venter commented,

    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

  • Avatar

    Hendrik Venter commented,

    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...

  • Avatar

    Hendrik Venter commented,

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

  • Avatar

    Hendrik Venter commented,

    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...

  • Avatar

    Hendrik Venter commented,

    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...

  • Avatar

    Hendrik Venter commented,

    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...

  • Avatar

    Hendrik Venter commented,

    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...

  • Avatar

    Hendrik Venter commented,

    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