Any ways to use laa with conditions?

Question & Answer
,
1

Hi I would like to combine those two caculations;

distinct_count({sequence},[{code},{status}])

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
2

Can you do something like this?

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

2 Likes
3

Thanks a lot Max! your solution helped a lot !

1 Like