Sometimes we want to create an exceptions UI that is beyond the regular options of the tool.
Specifically, something like this:
Let's see what was created by default and what is a customization...
To create the square near the "% profit" I used the standard Conditional Formatting:
Added an icon:
Add a note (you see it at the top right of the first image, only for the first line):
Since in the previous screen "Show rule condition" is marked, the Legend appears as well:
Now what about the extra column with the red and green squares?
Since I don't have this visualization built-in, I created a dynamic column, with the following calculation:
case
when @calculation("profit") < 0.1 then '๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ'
when @calculation("profit") < 0.2 then '๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฉ'
when @calculation("profit") < 0.3 then '๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฉ๐ฉ'
when @calculation("profit") < 0.4 then '๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฉ๐ฉ๐ฉ'
when @calculation("profit") < 0.5 then '๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฉ๐ฉ๐ฉ๐ฉ'
when @calculation("profit") < 0.6 then '๐ฅ๐ฅ๐ฅ๐ฅ๐ฅ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ'
when @calculation("profit") < 0.7 then '๐ฅ๐ฅ๐ฅ๐ฅ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ'
when @calculation("profit") < 0.8 then '๐ฅ๐ฅ๐ฅ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ'
when @calculation("profit") < 0.9 then '๐ฅ๐ฅ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ'
when @calculation("profit") < 1.0 then '๐ฅ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ'
else '๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ๐ฉ' end
How does it work? The red square and many others are valid characters... I only use them. See examples here:
https://unicodeplus.com/U+1F7E5
or here:
https://www.compart.com/en/unicode/U+1F7E9
The remaining problem is the Oracle Analytics automatic column width. The above-mentioned squares need more space than regular character.
As a "quick and dirty" work around I forced a longer column title:
You can always use "hard space" to force the longer header. Like this: " The percent of profit"
Copy/Paste from the blog wouldn't work here, but you can always create a hard space by holding the "ALT" key and pressing 255.
The same calculation works here as well (Watchlist UI):
Useful examples:
Orange Circle 1F7E0 - ๐
Yellow Circle 1F7E1 - ๐ก
Green Circle 1F7E2 - ๐ข
Purple Circle 1F7E3 - ๐ฃ
Brown Circle 1F7E4 - ๐ค
Red Sq. 1F7E5 - ๐ฅ
Blue Sq. 1F7E6 - ๐ฆ
Orange Sq. 1F7E7 - ๐ง
Yellow Sq. 1F7E8 - ๐จ
Green Sq. 1F7E9 - ๐ฉ
Purple Sq. 1F7EA - ๐ช
Brown Sq. 1F7EB - ๐ซ
Blue Heart 1F499 - ๐
Green Heart 1F49A - ๐
Yellow Heart 1F49B - ๐
Purple Heart 1F49C - ๐
Heart Decor 1F49F - ๐
White star 2B50 - โญ
Manual W-Chair 1F9BD - ๐ฆฝ 267F - โฟ
Nine Branches 1F54E - ๐
