Including multiple values on on card
I'm interested in creating a card that will show values from two different columns...
For example, I have a table that includes two columns:
-Sends
-Delivered
I'd like a card that has the sum of the Deliver column and also what percentage of the sends were delivered also in that card.
i.e. 500 delivers and 75% delivery rate.
Is there a way to do this?
Best Answers
-
You can use a beast mode with CONCAT to join multiple column values together.
CONCAT(SUM(`delivers`), ' delivers ', SUM(`delivers`)/SUM(`total`), '% delivery rate')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Minor edit to @GrantSmith 's suggestion, to re-format the percentage:
CONCAT(SUM(`delivers`), ' delivers ', ROUND((SUM(`delivers`)/SUM(`total`))*100,0), '% delivery rate')
1
Answers
-
You can use a beast mode with CONCAT to join multiple column values together.
CONCAT(SUM(`delivers`), ' delivers ', SUM(`delivers`)/SUM(`total`), '% delivery rate')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Minor edit to @GrantSmith 's suggestion, to re-format the percentage:
CONCAT(SUM(`delivers`), ' delivers ', ROUND((SUM(`delivers`)/SUM(`total`))*100,0), '% delivery rate')
1 -
Thank you! Is there a way to have commas inserted for large numbers exceeding 999?
0 -
@NathanDorsch you'll have to do it in the beast mode. @GrantSmith has a writeup on it here, and video link where he walked through it: https://dojo.domo.com/main/discussion/52677/domo-ideas-conference-beast-modes-number-formatting#latest
1 -
@MichelleH - Good catch, thanks!
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive