Adding '%' to a value in a column without affecting Visual Formatting based on number values

Copper Contributor

Hi Everyone,

 

I am new to Azure Data Explorer and was curious to know if it is possible to add a '%' string to an int without having to convert the int to a string? Furthermore, I am using this value to also project visual formatting colors within a table. I have used the strcat and strcat_delim but both do not abide by my visual formatting rules and cause it to not work properly as the value type string is persistent. For example, my column value would be 32.55(int) %(string) and the int would be used for my visual formatting. Is this possible? 

 

Thanks in advance!

 

0 Replies