How to Create Multiple Summary Numbers

2»

Answers

  • sgraham
    sgraham Member

    Yes I tied saving but still it just displays the code

     

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

  • [Deleted User]
    [Deleted User] Member

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

     

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

     

    Thanks!

  • evanbench
    evanbench Domo Employee
    Answer ✓

    I took several of the solutions to get it working: Scott Thompson's code with the down arrows Plus mitel's code for the color changes, plus richard's code for the dynamic jscript updates. Then it works as requested for my requirements.

  • [Deleted User]
    [Deleted User] Member

    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,

  • kristik
    kristik Member

    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 Member

    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-_ Coach

    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 Member

    I am using text in Fiscal Period  

    For Eg : FY18Q1

     

Categories