Concat + Round
Hello, I need a text card that has a specific text concatenated to a beast mode, which is a percentage value.
Currently I have the syntax as:
Concat(TEXT, Round(BeastMode*100,2))
But it returns this
And my scrap values is of 2.09% (0.02089 in the beast mode before multiplying by 100)
Any help provided is appreciated.
Thanks in advance.
Best Answer
-
I did but it didn't work as expected
Anyways I solved it with the Header/Footer chart option. I just added the text as Header and then the beast mode calculation set up as percentage and that did the trick
0
Answers
-
Did you check your formatting options in in the optional value field? You can control what data type it should be and the decimal places just like you do on any other card. You can even choose percentage, so you don't have to do any beast mode gymnastics.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
I did but it didn't work as expected
Anyways I solved it with the Header/Footer chart option. I just added the text as Header and then the beast mode calculation set up as percentage and that did the trick
0 -
Hey Martin,
If i had to guess you have an error in when your beastmode evaluates the concat.
Can you confirm that Round(BeastMode*100,2) delivers the expected result in a table card?
Does your CONCAT function wrap an aggregation or does it evaluate at the row level?
consider the differnece between:
concat('text', round(`metricA` / 1000,2))
concat('text', round(sum(metricA) / 1000,2))
the first will calculate at the row-level whereas the second will calculate AFTER aggregation. If I use the first calculation, you might get A result, but it's probably not the expected result.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive