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
-
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.
0
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
0 -
@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
0 -
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.
0 -
@Manasi_Panov It worked. Thank you so much!!
0 -
@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)?
0 -
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1 -
@Manasi_Panov Thank you!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive