Cards, Dashboards, Stories
Cards, Dashboards, Stories
Number abbreviations
Hello!
Is it possible to abbreviate numerical quantities displayed as currencies inside analyzer? For example, in the picture below it says 21 but that is times 1 BN. Is there a way to include the 1 BN abbreviation without having to do any sort of modification inside the ETL?
Thanks!
Welcome!
Best Answers
-
You could just create a beastmode that is `your value` * 1000000000.
Then in the chart properties, select General > Divide Values by > Billions.
End result (this original number in my data is 95.72, once I take the steps above I get the below):
If I solved your problem, please select "yes" above
1 -
CONCAT(DIVIDE(`YourColumn`, 1000000000), ' BN')
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
CONCAT('$',`Your_Column`,'B')
Though I like Colemen's solution much better. If you use mine instead, please also mark his as a solution, as it's solid.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
You could just create a beastmode that is `your value` * 1000000000.
Then in the chart properties, select General > Divide Values by > Billions.
End result (this original number in my data is 95.72, once I take the steps above I get the below):
If I solved your problem, please select "yes" above
1 -
CONCAT(DIVIDE(`YourColumn`, 1000000000), ' BN')
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
CONCAT('$',`Your_Column`,'B')
Though I like Colemen's solution much better. If you use mine instead, please also mark his as a solution, as it's solid.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive