topic If condition to set analysis expression in App Development

If condition to set analysis expression

LoKi_asterix — Wed, 25 Dec 2024 08:27:42 GMT

Hi All,
The expression as first expression/Column(1) which counts unique IDs as expected

Sum(Aggr(If(Count(DISTINCT {$<Year={'$(vMaxYear)'}>} IDs) = 1, 1), IDs))

I have this expression in the next expression tab

IF(COLUMN(1) > 0 AND LEN(TEL) > 0, COUNT(DISTINCT TEL))

I’m looking to optimize this for better performance on the front end by incorporating Set Analysis where possible.

Any suggestions for improvement would be greatly appreciated. Thanks!

Daniel_Pilla — Tue, 31 Dec 2024 14:21:02 GMT

It looks like you already have the proper set analysis. Provided that the "IDs" field are unique IDs, the first expression can be replaced with:

Count({$<Year={'$(vMaxYear)'}>} DISTINCT IDs)

{$<Year={'$(vMaxYear)'}>} Count(DISTINCT IDs)

For the second, if I'm understanding this properly, if you were to ensure that the empty values of "TEL" are in fact null, you could use

Count({<IDs={"=Count({$<Year={'$(vMaxYear)'}>} DISTINCT IDs)>0"}>} DISTINCT TEL)