Can I show a percentage of a Summary Number underneath the Summary Number?

Joe_M
Joe_M Member

Good morning,

 

Is there a way to display a percentage of the whole Summary Number, underneath the summary number? For example, in the screenshot below, would I be able to display that 20% of Total Streams (the 8.7M number)  came from Paid users? 

 

Thanks!

Tagged:

Comments

  • Cartergan
    Cartergan Contributor

    You wouldn't be able to display anything underneath, but you can create a BeastMode calculation Concatinating two or more values which you can then display as the summary number. Here is an example of production from number of loans I used:

    2020-05-20 09_29_11-Branch_Department Dashboards _ Lending Call Center - Domo.png

  • @Cartergan  and @Joe_M ,

     

    you can use HTML in summary numbers to create a ... formatted summary number:  https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/HTML-in-Summary-Number/m-p/22473#M2517

    try creating a beast mode that shows two metrics on two lines by inserting a line break, <BR> tag.

    once you figure that out, then to create percent of total that's just 

    sum(case statement) / sum(sum(amount)) over ()

     

    you may need to ask your CSM to enable windowed functions in Beast Modes.

    i made a tutorial example:  https://www.youtube.com/watch?v=ZPf41Fjn1H8

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ 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.