How to Create Multiple Summary Numbers

2»

Answers

  • sgraham
    sgraham ⚪️

    Yes I tied saving but still it just displays the code

     

    I then tried to replace the img src with the alt 24

  • DaniBoy
    DaniBoy

    domo

    💎

    @sgraham and @ST_-Superman-_ great collaboration here!

     

    Are any the latest replies working solutions so that I can give credit as a solution?

     

    Thanks!

    Dani aka "Mr.Dojo"

    Dojo Admin
    **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"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
  • DaniBoy
    DaniBoy

    domo

    💎

    Thanks @evanbench,

     

    I am going to bring in our education team to create an article on this in our Knowledge Base Help Center based on this thread.

     

    Regards,

    Dani aka "Mr.Dojo"

    Dojo Admin
    **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"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
  • kristik
    kristik

    I have been unable to get cards what have multiple summary numbers (using concat) to be included in my Favorites daily alert.  Apparently such numbers are treated as text after the concat is applied.  Is there a way to add a hidden value outside of the concat function so that it will be included in the Favorites daily alert but won't necessarily appear in the sub-heading itself?

  • SayandeepKundu
    SayandeepKundu

    concat(SUM(case when `Latest` = 'Y' then `Outbound Traffic` end),' ','Latest Quarter',' ','-',' ',`Fiscal Period`)  

    I used the code in  MYSQL and could get the required result and  tried to do the same using beast mode to get the summary number but failed.

  • ST_-Superman-_
    ST_-Superman-_ 🟤

    What is the data in Fiscal Period?  You need to aggregate that field as well. 

     

    Instead of `Fiscal Period` you need something like MAX(`Fiscal Period`)

     


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

    I am using text in Fiscal Period  

    For Eg : FY18Q1

     

Categories