Two or more Fields on Summary

How can i show show two or more Fileds value on "Summary Number"?

 

I tried creating a calculated Field to include 2 or more fields however it shows really weird format on the card i.e. without comma for Numeral values and large font size.

 

See attached Screenshot of one of the cards. 

Best Answer

Answers

  • KurtF
    KurtF Domo Employee

    When you concatenate values together MySQL treats them all as text. That's why you lose the automatic formatting of numbers that Domo usually does for you.

     

    You would have to format the number as a string with the commas inserted in the correct spots and then concatenante together. This will be tricky to do based on how the length of the number varies. You should be able to do something like this:

     

    CONCAT('Total quote premium: ', 

          CASE WHEN LENGTH(`Total Quote Premium`) = 6

                THEN CONCAT(LEFT(`Total Quote Premium`, 3), ',' ,RIGHT(`Total Quote Price`,3))

          WHEN LENGTH(`Total Quote Premium`)=7

                THEN CONCAT(LEFT(`Total Quote Premium`,1), ',', SUBSTRING(`Total Quote Premium`,2,3), ',',

                    RIGHT(`Total Quote Price`,3)) . . . END

    )

     

    You would need to have cases that support each of your possible number lengths. The above snippet only handles items in the hundreds of thousands and millions. Hopefully this is enough for you to get the idea.

    KurtF
    **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"
  • Thank You. However,this looks very complicated and it does not resolve the issue with the font size. i wish i had something more easy and simple.

  • KurtF
    KurtF Domo Employee
    Answer ✓

    Whenever you are combining fields in a Summary Number it can get complicated.

     

    Here is link on how to handle font size via HTML tags:

    https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-do-I-change-font-size-for-summary-number-display/m-p/23226

    KurtF
    **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"
This discussion has been closed.