Does custom expression support counting fields that meet specific conditions?

1

Does custom expression support counting fields that meet specific conditions? eg：COUNT(DISTINCT CASE WHEN [field]=1 THEN [field] ELSE NULL END

image
image1244×764 34.2 KB

2

Check out the expression countif() function CountIf

3

It doesn't seem to work. How can countif be combined with distinct because it still needs to be deduplicated

4

Not sure if you can combine them like that sorry.

Could you do your condition as the filter then your count distinct in the summary? i.e.:

image
image682×745 22.7 KB

Depends what you're trying to get out. Sometimes you just need to do it in SQL. I find doing the SQL as a model, then using that in the query builder works quite well.