How to show the rating for each order

Hello Team,

I my dataset I two fields, Order number and Severity, as shown in the below example.

Could you please assist me, is it possible calculate the rating field as shown in the table. When we have multiple defects in the order, we need to show the highest severity in the rating column.

image

Hi,

you can add calculated field and assigned number as if servility = ‘minor’ than 1 else servility = ‘significant’ than 2 and so on

and based on the number you can show the higher/lower number in rating. You can use another filed like if new filed = 1 than ‘minor’ this will show in character

Regards,
Naveed Ali