Can a column have both percent and whole number line items and be reflected as is on a table card?
I have yearend groups data that I am trying to combine using Sharepoint Excel spreadsheets.
There are columns that has line items for annual target of Percent and others as Numbers.
The input data looks alright on the load, but the Table card does not display the whole number
values and just is diaplaying the percent as decimals.
Is this scenario acceptable or a given column needs to have only one format for all values?
Comments
-
If you're wanting to include multple variations of formatting for a single column in a table, you would need to either format the values and add them to a 'TEXT' column type or you could try to create a BeastMode to address the various scenarios you need.
Something like this:
CASE WHEN `Category` = 'A' THEN CAST(`Value` AS DECIMAL(10,2))
WHEN `Category` = 'B' THEN CONCAT(`Value`,'%')
ELSE `Value`
ENDLet me know if you have any other questions on this.
Sincerely,
Valiant**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.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