Setting status of data
I am trying to set the status of a row based off of other data... let me show you an example:
Number status new_Status
1 dev test
1 test test
2 dev dev
so if there is test in the "status" column I want the new status to be test for all instances of the number
what formula do I need for new_status??
Playing off of Mike's idea above, you might think to include an intermediary formula to order those nominal values. This would allow you to rank as many statuses as you wish, regardless of their alphabetical order.
if ( status = "dev" ) then concat ( "01 - " , status ) else if ( status = "test" ) then concat ( "02 - " , status ) else null
group_max ( ordered_status , number )