Two or more Fields on Summary
How can i show show two or more Fileds value on "Summary Number"?
I tried creating a calculated Field to include 2 or more fields however it shows really weird format on the card i.e. without comma for Numeral values and large font size.
See attached Screenshot of one of the cards.
Best Answer
-
Whenever you are combining fields in a Summary Number it can get complicated.
Here is link on how to handle font size via HTML tags:
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
When you concatenate values together MySQL treats them all as text. That's why you lose the automatic formatting of numbers that Domo usually does for you.
You would have to format the number as a string with the commas inserted in the correct spots and then concatenante together. This will be tricky to do based on how the length of the number varies. You should be able to do something like this:
CONCAT('Total quote premium: ',
CASE WHEN LENGTH(`Total Quote Premium`) = 6
THEN CONCAT(LEFT(`Total Quote Premium`, 3), ',' ,RIGHT(`Total Quote Price`,3))
WHEN LENGTH(`Total Quote Premium`)=7
THEN CONCAT(LEFT(`Total Quote Premium`,1), ',', SUBSTRING(`Total Quote Premium`,2,3), ',',
RIGHT(`Total Quote Price`,3)) . . . END
)
You would need to have cases that support each of your possible number lengths. The above snippet only handles items in the hundreds of thousands and millions. Hopefully this is enough for you to get the idea.
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thank You. However,this looks very complicated and it does not resolve the issue with the font size. i wish i had something more easy and simple.
0 -
Whenever you are combining fields in a Summary Number it can get complicated.
Here is link on how to handle font size via HTML tags:
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive