Show numbers in different format
Hi! I have a stacked bar chart whose formatting for values must follow a specific set of rules. If it is above 1 million (example 9,483,321), it will be displayed with 1 decimal place, scale-abbreviated (to 9.5M in the example). If it is below 1 million, it should be displayed with no decimal place, scale abbreviated (like 570,754 to 571K). This should be for the totals and values per category. Is this possible to do currently in DOMO?
Best Answer
-
In your y-axis, choose Format and Display as Number and set the number of decimals to 1. Then in the Chart Properties - Data Label Settings, select Use Scale Abbreviation. This might get you what you want.
**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.0
Answers
-
In your y-axis, choose Format and Display as Number and set the number of decimals to 1. Then in the Chart Properties - Data Label Settings, select Use Scale Abbreviation. This might get you what you want.
**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.0 -
@Patrick_Cruz - I'm not sure of a way to accomplish this. I believe this would need to be a feature request. There may be a way to accomplish this kind of labeling using a DDX brick, but I don't have the coding skills to help you there.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive