Including multiple values on on card

NathanDorsch

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?

GrantSmith

You can use a beast mode with CONCAT to join multiple column values together.

 CONCAT(SUM(`delivers`), ' delivers ', SUM(`delivers`)/SUM(`total`), '% delivery rate')

MichelleH

Minor edit to @GrantSmith 's suggestion, to re-format the percentage:

CONCAT(SUM(`delivers`), ' delivers ', ROUND((SUM(`delivers`)/SUM(`total`))*100,0), '% delivery rate')

GrantSmith

You can use a beast mode with CONCAT to join multiple column values together.

 CONCAT(SUM(`delivers`), ' delivers ', SUM(`delivers`)/SUM(`total`), '% delivery rate')

MichelleH

Minor edit to @GrantSmith 's suggestion, to re-format the percentage:

CONCAT(SUM(`delivers`), ' delivers ', ROUND((SUM(`delivers`)/SUM(`total`))*100,0), '% delivery rate')

NathanDorsch

Thank you! Is there a way to have commas inserted for large numbers exceeding 999?

mhouston

@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

GrantSmith

@MichelleH - Good catch, thanks!