Any ways to use laa with conditions?

Hi I would like to combine those two caculations;


distinct_countif({sequence},date >=startdate and date<=enddate)

meaning that I would like to do counting sequence by code and status
with giving conditions of specifict dates.
date >=startdate and date<=enddate

Is the any ways to do laa with conditions?
Thanks in advance!

1 Like

Can you do something like this?

distinct_count(ifelse({date}>=${startdate} AND {date}<=${enddate},{sequence},NULL),[ {code},{status}])


Thanks a lot Max! your solution helped a lot !

1 Like