Looker

How to add order:

case(
 when(${study_phase} = "Prescreening",1),
#  when(${states} = "HIPAA Authorization",1),
 when(${study_phase} = "Consent",2),
 when(${study_phase} = "Eligibility",3),
 when(${study_phase} = "Onboarding",4),
 when(${study_phase} = "Enrollment",5),
 when(${study_phase} = "Baseline / Month 1",6),
 when(${study_phase} = "Month 2",7),
 when(${study_phase} = "Month 3",8),
 when(${study_phase} = "Month 4",9),
 when(${study_phase} = "Month 5",10),
 when(${study_phase} = "Month 6",11),
 when(${study_phase} = "Month 7",12),
 when(${study_phase} = "Month 8",13),
 when(${study_phase} = "Month 9",14),
 when(${study_phase} = "Month 10",15),
 when(${study_phase} = "Month 11",16),
 when(${study_phase} = "Month 12",17),
 when(${study_phase} = "End of Study",18),
 when(${study_phase} = "Completed",19),
 when(${study_phase} = "Withdrawn",20),
 when(${study_phase} = "Opted Out",21),
 when(${study_phase} = "Failed Screening",22),
 when(${study_phase} = "Failed Prescreening",23)
 ,99)