HTML in Summary Number

Hey all!

HTML is not enabled in summary numbers correct?

Find more posts tagged with

Accepted answers

Actually, you can use HTML in summary numbers. To do that you have to encapsulate the HTML tags in single quotes to make it beastmode/mysql friendly. It's not always for the faint of heart, but if you are comfortable with beastmodes and html you can do some nice things. I have used it to color-code numbers green or red, depending on if they are above or below a certain target.

jaredpk

Here is one that changes the beastmode fonts as an example:

CONCAT(
'<div style="background-color:#bbe491; color:#000000; font-weight:bold; width: 100%; height:100%; margin:-20px; padding:20px">', '+$', `WoW Revenue Change`, ' (+', `WoW Percent Change, '%)','</div>'

)

mbelmont

Are you sure you are not changing anything? I am getting a fine result and all I did was switch fields to those in my dataset (also a string field)

CONCAT('<div class="big_number_option" style="color:#000000; line-height: 10px; padding:7px;font-weight:normal">',
MAX(CASE
When `19` = 'Purchase' then 'Regular'
Else `19`
End),'</div>')

diagnostic.PNG

mbelmont

CASE
WHEN IS NULL `DATE.001`
THEN CONCAT(AVG(`NUMBER.001`),<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', 'RESPONSE 1', '</a></div>')
WHEN IS NULL `DATE.002` AND DATEDIFF(CURRENT_DATE(),`DATE.001`) > 2 AND `STATUS.001` = 'Alpha'
THEN CONCAT(AVG(`NUMBER.001`),'<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', 'RESPONSE 2', '</a></div>')
END

Let me know if that doesn't make sense, I edited this for the thread.

All comments

[Deleted User]

Try looking through these articles:

https://knowledge.domo.com/Special:Search?qid=&fpid=230&fpth=&path=&search=HTML+in+summary+numbers

Thanks!

shivashankar_Pi

Hi,

When I used this code CONCAT('<b>','Hello World','</b>') in the card Textbox (Table) or in Single Value card in Gauges, its giving me text as is "<b>Hello World</b>" while my expectation is that it should bold the "Hello World".

Is Summary Number a different type of card if so where would I find it?

Thank you,

Shiva

Tatyana_K

Are you saving the card after you've applied the summary number? You will continue to see the HTML code until you save the card to which it should display as expected.