Increase Bubble Chart Size
I'm using bubble chart now, to show Sales by Region.
Some value of sales are in Billion unit while other also in Million.
It really doesn't make sense when user choose Year A it show perfect bubble,
then Year B size very small.
How to adjust the size? Already consider to rescale the data but then it'll affect the data accuracy. Hence i don't use this option. Please advise me.
Best Answer
-
Can you transform your data in an ETL? Apply a formula like
Log(Value)
orValue / Scaling Factor
to adjust the bubble sizes.
Create a calculated field to adjust the size values directly. A formula to scale down or normalize your values. For example,Size = [Original Size] / 1,000,000
to convert billions to millions.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
Can you transform your data in an ETL? Apply a formula like
Log(Value)
orValue / Scaling Factor
to adjust the bubble sizes.
Create a calculated field to adjust the size values directly. A formula to scale down or normalize your values. For example,Size = [Original Size] / 1,000,000
to convert billions to millions.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
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
- 816 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
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 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
- 115 Community Announcements
- 4.8K Archive