How do I replace text with unicode

suwandy

Hello,

 

I'm trying to replace some characters in my table using Unicode Characters such as :white_heavy_check_mark: and with :cross_mark: 

This is the code I typed into the Beast Mode but it's not displaying it and instead only showed the literal '✅', could anyone please help?

 

Case when `Last Week Actual` - `Last Week Target` >= -9999 then 
'✅'
when `Last Week Actual` - `Last Week Target` >= 0.001 then 
'❌'
else '' End

Thanks in advance.

Ashleigh

Hiu @suwandy  you have to include the <div> tag like this, I also attached a photo of what it showed. 

 

 

CONCAT('<div style="">', -- Combine data and format

'&#9989;',

' Hello ', COUNT(`IMPL_DT`),

'</div>' -- end format

)

Ashleigh

Here is a knowledge base article with some other examples. 

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Adding_Graphics%2C_Links%2C_and_Images_to_Table_Cards_Using_Beast_Mode

suwandy

Hello there,

 

Thanks for your response. I tried it however it only gave me this result instead (see attachment) 

 

This is the new code I used. 

 

Case when `Last Week Actual` - `Last Week Target` >= -9999 then 
CONCAT('<div style="">', '&#9989;', ' Hello ', '</div>' )
when `Last Week Actual` - `Last Week Target`  >= 0.001 then 
CONCAT('<div style="">', '&#9989;', ' Hello ', '</div>' )
else '' End

 By the way, I couldn't see the photo you attached. Could you attach it again please? 

Ashleigh

@suwandy To see the image you have to download, for some reason they do not show just by clicking on it (could be computer security settings). I did not realize you were trying to get it in a table; the code I provided was for a summary number. I think to put it in a table you will want to use an image rather than the Unicode. In the link I provided in my last message, there is a section for how to add images to a table. I went ahead and did an example. Here is my code:

 

Case
when `Entered Hours` > 0 then CONCAT('<div style="text-align:center"><img alt="UP" height="20px" src="https://s3.amazonaws.com/pix.iemoji.com/images/emoji/apple/ios-12/256/white-heavy-check-mark.png">','</div>')

 

when `Entered Hours` <=0 then CONCAT('<div style="text-align:center"><img alt="UP" height="20px" src="https://banner2.kisspng.com/20180715/klo/kisspng-check-mark-emojipedia-computer-icons-symbol-cek-5b4bdef7a0b662.6919404015316989356583.jpg">','</div>')

else ''

End

 

Download the image to see what it made. 

Ashleigh

To get the links I just searched up the emoji and then right clicked on an image and selected copy image address