I have a column of data that can take on about 20 enumerated values.
I am looking for the total time the parameter is in 5 of these states. I have already started using
duration_in(state_agg(dtm, target_status), '10')
but what I think I really want is something like
duration_in(state_agg(dtm, target_status), IN ('7', '10', '11', '12', '15')
How can I get the total duration of multiple states?