LinkedIn
Twitter
This tip and trick started based on the requirement of the following post.
With this tip you can show Red , Yellow , Green ( and other ) status in color in reports created through templates.
The tip is inspired by previous tips by @Fabian_Weller
https://www.googlecloudcommunity.com/gc/Feature-Ideas/Customize-TEXT-ICON/idi-p/323786
and @Koichi_Tsuji
and similar others
Basically to show the red, yellow , grren status one uses these palceholder images based on status.
The app formula for the thumbnail type color image column [StatusCMonth] in the example is something like
CONCATENATE("https://placehold.jp/",SWITCH([Current Month],"Red","ff0000","Green","228C22","Yellow","FFCC00","000000"),"/ffffff/150x150.png?text=",[Current Month])
Please change the SWITCH() expression to suitably modify the expression as per your requirement, of "red", "Yellow", :Green" status requirements. The thread below shows teh status for various risk values.
For [StatusPmonth], replace [Current Month] with [Previous Month] in the above expression.
Here based on status of the [Current Month] or [Previous Month] column a hex color code value for the placeholder image is chosen. The backend data looks like somethibg below
The report output looks like something below
You will obviously need to change the concatenate expression a bit to match your requirement. Since I was unware of your exact requirement , I shared a general expression that you can easily modify . I have modified it as below.
The modified expression will now create the images with colors and risk values embedded therein as per your shared requirement.
The column [Risk Value] is number type and consists of risk values and the column [StatusCMonth] is Thumbnail type, with the concatenate expression as app formula as given below.
CONCATENATE("https://placehold.jp/",
IFS([Risk Value]<=4 ,"228C22",
[Risk Value]<=10 , "FFCC00",
[Risk Value]>10,"ff0000"),
,"/ffffff/150x150.png?text=",[Risk Value])
The report now looks like below
You will put it in the column of thumbnail type. The column will create those images based on risk value column.
You can create report template to include only thumbnail type column, because it has risk value included along with the status color image.
Hope this explains. Please do revert if you have any more query. The report template of the report image I shared above alooks like below. [StatusCMonth] is the column that has the concatenate expression and then creates those status color images with risk value embedded.
This is my Hazard table. The three risk factors are Factor 1, Factor 2 and the result, Factor 3, is 1 multiplied with 2. Factor 3 is the one I want to output in the appropriate colour. The formula box therefore multiplies them. Do I need to create another column for the thumbnail that copies that and contains your Concatenate formula?
Hi @Suvrutt_Gurjar , very nice ! Do you know how to avoid this corner blur when using border-radius CSS parameter?
