Avatar

Hamza Jap-Tjong

  • Total activity 113
  • Last activity
  • Member since
  • Following 1 user
  • Followed by 1 user
  • Votes 2
  • Subscriptions 50

Activity overview

Latest activity by Hamza Jap-Tjong
  • Avatar

    Hamza Jap-Tjong commented,

    You cannot use strings in your CASE/IF-functions. Not as variable and not as result. You can only use values.    The function-field should be searchable/scrollable. Both the CASE and IF functions a...

  • Avatar

    Hamza Jap-Tjong commented,

    I do not know how your table looks like specifically , however you can use date-functions to extra for example a timestamp. If you have a start time and an endtime you could subtract these two from...

  • Avatar

    Hamza Jap-Tjong commented,

    I struggle with this aswell sometimes. However I use this workaround (not always applicable) case  when (COUNT([ID]), [COUNTRY]) >0 then 5 else 0 end   You can copy the when statement multiple time...

  • Avatar

    Hamza Jap-Tjong commented,

    You could check the log-files. I think it is called API-gateway, but maybe Galaxy would work as well.   What error message (/ response) are you getting?   Depending on your version, the logs files ...

  • Avatar

    Hamza Jap-Tjong commented,

    Hi Akondi,   You can use one of the ready to go scripts with shared recently: https://support.sisense.com/hc/en-us/community/posts/360033937833-GeriMedica-s-Sisense-Toolkit You can use the Pivot PD...

  • Avatar

    Hamza Jap-Tjong commented,

    Hi Madhur,   If you need any assistance, let me know and we can jump on a call. I have that tool up and running and it works nicely. I also have a previous versions in which you could see the code....

  • Avatar

    Hamza Jap-Tjong commented,

    How can I make it open in a new tab when you are using v7+? Cannot find the anchor as being referenced in earlier post

  • Avatar

    Hamza Jap-Tjong commented,

    I do not think it is possible with Blox, however with the Smartlabel plugin this is possible (but you do not have any other options like Blox)

  • Avatar

    Hamza Jap-Tjong commented,

    Hi Roopa, Sisense does offer a dynamic time filter on the front-end, so you do not necessarily have to do a CASE.  In your case I would not represent a timestamp in your column. I would take a text...

  • Avatar

    Hamza Jap-Tjong commented,

    Hi Roopa,   The reason why you are getting N/A is because you are selecting/importing all Date values from your fact_energy.  In other words you are getting every value and only for the values that...