Avatar

David Hertzberg

  • Total activity 252
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 75
  • Subscriptions 114

Activity overview

Latest activity by David Hertzberg
  • Avatar

    David Hertzberg commented,

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

  • Avatar

    David Hertzberg commented,

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

  • Avatar

    David Hertzberg commented,

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

  • Avatar

    David Hertzberg commented,

    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.

  • Avatar

    David Hertzberg commented,

    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.

  • Avatar

    David Hertzberg commented,

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

  • Avatar

    David Hertzberg commented,

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

  • Avatar

    David Hertzberg commented,

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

  • Avatar

    David Hertzberg commented,

    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.

  • Avatar

    David Hertzberg commented,

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