Does anyone have the Beast Mode with HTML code to include an up or down arrow into a card?

debbie_a · July 2018

I need to create a header that displays some text (users don't always click on title for descriptions) . In order to have the beast mode availalbe to select as a header, it needs to have a calclation included. I was able to get it to work by adding sum(0+0), but 0 shows up in the text. I tried using IFNULL, but then nothing shows. What is the html code to use to make sum(0+0) appear in white font which would make it "disappear"?

thanks for your thoughts!!

CONCAT('<div class="big_number_option" style="color:#525859; margin-top:-4px;
font-weight:lighter">'
,' Grey shade indicates wkly data is in future releases or N/A '
,' <br> '
,' Total row will not equal the sum of the parts due to',' <br> ' , 'mix of industry sales and growth rates vs LY '
,' <br> '
, sum(0+0)
,' <br> '

,' </div>' )

cwolman · July 2018

The beast mode below should help:

concat('<div style="color: green">Your text here</div>','<div style="color: white">',sum(0+0),'</div>')

This case statement will display an up or down error or nothing based on value of the revenue field.

concat(

case
when sum(`revenue`)>0 then ' ⇧ '
when sum(`revenue`)<0 then ' ⇩ '
else ''
end

)

cwolman · July 2018

The beast mode below should help:

concat('<div style="color: green">Your text here</div>','<div style="color: white">',sum(0+0),'</div>')

This case statement will display an up or down error or nothing based on value of the revenue field.

concat(

case
when sum(`revenue`)>0 then ' ⇧ '
when sum(`revenue`)<0 then ' ⇩ '
else ''
end

)

debbie_a · July 2018

thank you!

Does anyone have the Beast Mode with HTML code to include an up or down arrow into a card?

Best Answer

Answers

Categories