How do I avoid decimals from being truncated while bringing data from Excel?
I have an Excel that has several measures that are percentages. The Excel is in a Box folder, so I am using the Box connector to bring the data to a Domo dataset. Everything works fine, except that the percentages get converted to decimal numbers (so, all are <1) and truncated to 2 decimals... so that is causing me issues when I use the SUM option for those percentages in my visualizations.
How do I fix it? Thanks!
Best Answer
-
The values are still there. They have just been imported as type DOUBLE. Depending on what you are wanting to do with the data, you can either convert it in MySQL using something like this:
SELECT convert (`General`, decimal(9,7)) as `General` from dojo_help_2
You can use an ETL by usint the "Set Column Type" action and changing the data type to Decimal(Fixed)
You can just change the chart options to display it as a number with x decimals:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
The values are still there. They have just been imported as type DOUBLE. Depending on what you are wanting to do with the data, you can either convert it in MySQL using something like this:
SELECT convert (`General`, decimal(9,7)) as `General` from dojo_help_2
You can use an ETL by usint the "Set Column Type" action and changing the data type to Decimal(Fixed)
You can just change the chart options to display it as a number with x decimals:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 680 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive