Including multiple values on on card

NathanDorsch
NathanDorsch Member
in Charting

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

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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!**
  • MichelleH
    MichelleH Coach
    Answer ✓

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

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

Answers

Categories