Syntax issue for the beastmode concat ( text column)

art_in_sky

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

Manasi_Panov

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

ColemenWilson

If I am understanding correctly you would do the following:

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

art_in_sky

@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

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

art_in_sky

@Manasi_Panov It worked. Thank you so much!!

art_in_sky

@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

Hi @art_in_sky,

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

and the formula:

art_in_sky

@Manasi_Panov Thank you!