Syntax issue for the beastmode concat ( text column)

I am currently having a column with different data types ( there are null, text, percentage -ve numbers, numeric values ) indicated as text column.

The dataset displays %, -ve values. However , when cards are created, they only display the numbers but not the %. I tried creating beast mode for certain rows, however i get the syntax issue.

How do I indicate %, $ all of them in one column

Best Answer

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    Hello @Arthi Annadi,

    Why not use the Tooltips function to display % or $ on the cards? Here is more info on this topic:

    https://community-forums.domo.com/main/discussion/comment/97940#Comment_97940

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

Answers

  • If I am understanding correctly you would do the following:

    CONCAT(CASE WHEN fieldThatIndicatesDataType = 'Dollars' THEN '$' WHEN fieldThatIndicatesDataType = 'Percentage' THEN '%' ELSE '' END,`Value`)

    If I solved your problem, please select "yes" above

  • @ColemenWilson I am using a text column that indicates everything in the data set such as xx%, $xx. However, it only indicates the numeric numbers in the charts, i tried using beastmode to concatenate the text with $ or % , it throws me a syntax error

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    Hello @Arthi Annadi,

    Why not use the Tooltips function to display % or $ on the cards? Here is more info on this topic:

    https://community-forums.domo.com/main/discussion/comment/97940#Comment_97940

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

  • @Manasi_Panov It worked. Thank you so much!!

  • @Manasi_Panov I used the tool tips and variables and it worked. However, If I have to use it together for a table chart as a column ( how can i achieve to show the units next to the my column values)?

  • Manasi_Panov
    Manasi_Panov Contributor

    Hi @art_in_sky,

    Then you have to use the CONCAT function. Here is a simple example:

    and the formula:

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

  • @Manasi_Panov Thank you!