Show more than one summary numbers

Is it possbile to show more than one summary numbers at the same time? Say overall average,target, and difference between last month value and target?

Best Answers

  • ST_-Superman-_
    Answer ✓

    you can create a beastmode to concat the different values that you want to include.  Then you would want to select that beastmode as your summary number.  This does cause some issues when exporting the cards in different ways, so make sure that you test it out.

     

    concat("calculated value",' text ',"calculated value 2", ' text 2 ' ... etc )

     

     


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • jhl
    jhl Member
    Answer ✓

    There is a knowledge base article on customizing your summary number here.

    Code example: 

    CONCAT(Sum(CASE when `Status` <> ’New' then 1 END),' Total, ',sum(case when `Date` >= date_sub(curdate(),INTERVAL 1 MONTH) then 1 else 0 end),' In Last 30 Days’)

Answers

  • ST_-Superman-_
    Answer ✓

    you can create a beastmode to concat the different values that you want to include.  Then you would want to select that beastmode as your summary number.  This does cause some issues when exporting the cards in different ways, so make sure that you test it out.

     

    concat("calculated value",' text ',"calculated value 2", ' text 2 ' ... etc )

     

     


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • @user03079,

     

    Please click on "Accept as Solution" on any reply that may have solved your problem.

    Thanks!

  • jhl
    jhl Member
    Answer ✓

    There is a knowledge base article on customizing your summary number here.

    Code example: 

    CONCAT(Sum(CASE when `Status` <> ’New' then 1 END),' Total, ',sum(case when `Date` >= date_sub(curdate(),INTERVAL 1 MONTH) then 1 else 0 end),' In Last 30 Days’)

This discussion has been closed.