Custom exceptions UI in OAC/OAS table

 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 - 🕎