topic Re: COUNT DISTINCT right after having set multiple conditions into an IF statement (graph expression) in App Development

COUNT DISTINCT right after having set multiple conditions into an IF statement (graph expression)

theo_pf — Fri, 15 Nov 2024 23:24:35 GMT

I need to count distinct occurrences into a dataset which meet three conditions.

Until now I've tried with something like follows:

=COUNT(DISTINCT(IF(condition_1 = True AND condition_2 = True AND condition_3 = True, row)))

While it worked perfectly using just two conditions, it is when I add the third one that, even if the expression editor doesn't show any warning message, the output I get is entirely wrong when I check it on my data warehouse.

How should I tweak the expression so it gives me a correct output?

Re: COUNT DISTINCT right after having set multiple conditions into an IF statement (graph expression)

sasikanth — Thu, 16 Dec 2021 14:55:14 GMT

Try below one, please share your original expression if the below one doesn`t work

COUNT(DISTINCT

IF(

(condition_1 = True AND condition_2 = True )

AND

(condition_3 = True)

, row)

)

Thanks,

Sasi

Re: COUNT DISTINCT right after having set multiple conditions into an IF statement (graph expression)

Or — Thu, 16 Dec 2021 14:56:45 GMT

You'll have to be more specific about the data structure and conditions. There's no limit on the number of conditions, so I'm guessing the third condition is problematic in itself, rather than the expression in general.