Number Format in a Table
I have a table that shows different number formatting within the same column. Is there a way to keep the different formatting?
Example:
Row 1: Percentage
Row 2: Whole Number
Row 3: Number with two decimal points
I am not seeing any articles on this.
Comments
-
You can set the number format for a whole column by clicking the pencil on the field name, then clicking "Data Format". Then you will see a drop-down where you can select the format you want.
Also, if your data is showing up with different formats in the same column, be sure that the column is stored as a number rather than text. Otherwise these options will not be available.
0 -
That is the problem. I need different formats for each cell of the column.
0 -
I see, I misread your question. Out of curiosity, what is the reason behind having different data formats in the same column? I don't know of a way to do this offhand, but there may be another way to present it.
0 -
Boss man wants it that way. ?
Basically we want different stats showing by Month, Example:
Stat July August Total
Count of Stat 5,000 7,500 12,500
Total for Month 8,000 9,000 17,000
% of Stat 62.5 83.3 73.5
Since I don't need decimals for the counts, but do need them for the % of stats. I need each row formatted different.
0 -
Hi @user013269
You'd need to format them as a string in the format you wish using your query before you pull it into Domo.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
So bring it over as text formatted whatever way I want? OK
0 -
Alternatively, there is a transpose option in the general settings of table cards. Then you can store each stat separately as a number with their own formatting.
0 -
Hmm. Transpose just flips the columns and rows. Unable to update the numbers after it does that. But I will ask the boss man if I can put the Months on the Left and the Stat Types on the top.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive