LinkedIn
Twitter
Some apps have risks or some such other data that can be better shown in a matrix or grid format. An example post below
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Risk-Matrix-Calculation/m-p/354227
The sample below shows risk analysis matrix grid created with card view for a better visual presentation. The concept is simple.
1) The risks from the risk table are classified in various buckets based on impact and likelihood ( Severe-Possible, Moderate-Likely and so on). This risk list table serves as child table to the risk grid table. So risks acccording to classification are attached to respective card in the risk grid parent table described below.
2) The parent table is a card view based, The card view images are from the image rendering service. The risk list from risk table is shown with the respective risk grid.
The general expression for the image in each grid is
IFS(
OR([Attribute]="Moderate-Unlikely",[Attribute]="Moderate-Possible"), CONCATENATE("https://placehold.jp/20/228C22/000000/400x400.png?text=",IF(COUNT([Risk List])=0,"No Risk",TEXT([Risk List]))),
OR([Attribute]="Minor-Unlikely",[Attribute]="Major-Unlikely",[Attribute]="Minor-Possible",[Attribute]="Moderate-Likely"), CONCATENATE("https://placehold.jp/20/FFFF00/000000/400x400.png?text=",IF(COUNT([Risk List])=0,"No Risk",TEXT([Risk List])))
)
Basically based on risk category the expression above selects the color of the risk attribute ( impact and likelihood) bckground image and [Risk List] gets the list of risks for that risk grid fro the child table of risk list.
