Consider this characterization in Atlas (for a cohort of patients with a single GFR test).
I need help with how to (or if it is even possible) characterize the population based on lab value.
I want to count patients where their first GFR test falls into following bins
I don’t want to define 6 cohorts for this problem (I know it solves it) - because it is a classic use case for characterization. Don’t advise that!
Note that user has only Atlas access and can not do any custom code (Feedernet context).
I can hack the SQL right away (or an R package) - but it has to be done strictly inside Atlas. So I need advice for Atlas or some other “tool” (not plain SQL).
The result should tell me that out of 1000 patients, 800 have 90+, 120 have result 60-89, etc until all patients are classified. They are mutually exclusive.