How to Custom function

Comments

3 comments

  • Avatar
    Michael Becker

    Hi Qu,

    in that section you highlighted, at the bottom there are Other functions (you need to scroll own)

     

    There is If and Case there. Please note that CASE and IF work only with measures, so you can't apply consitions based on text in dimension. Hope it helps.

     

    Regards,

    Michael

    1
    Comment actions Permalink
  • Avatar
    Hamza Jap-Tjong

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

     

    Documentation: https://documentation.sisense.com/latest/creating-dashboards/using-formulas/conditional-statements.htm#gsc.tab=0

    1
    Comment actions Permalink
  • Avatar
    Qu Changzheng

    Thank you for your reply.

    There is no search bar in my page:

    My version is 5.7.51.23.

    Is that the reason?

    Can I upgrade to 7.1 or later?

    Are there any functional restrictions?

    Thank you very much!

    0
    Comment actions Permalink

Please sign in to leave a comment.