Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have formed this expression
Count( {<[reason is]={'this'}>+<[reason is]={'that'}>} distinct [row id])/ count([reason is])
and I get 0, while Count( {<[reason is]={'this'}>} distinct [row id]) alone is approx. 2000
and so is Count( {<[reason is]={'that'}>} distinct [row id]) .
What could possibly be wrong?
If you put values for a field separated by comma, they are OR by default in set analysis. Therefore, you could simply try like:
Count( {<[reason is]={'this', 'that'}>} distinct [row id])/ count([reason is])
your expression looks good.
what you get for the expression =count([reason is]) ?
43,7K 🤔
If you put values for a field separated by comma, they are OR by default in set analysis. Therefore, you could simply try like:
Count( {<[reason is]={'this', 'that'}>} distinct [row id])/ count([reason is])
Hi,
Try this;
Count( {<[reason is]={"this","that"}>} distinct [row id])/ count([reason is])
Thanks guys!
What would it be if I wanted the "and" clause?
PS: It's strange how in one app for "or" the plus sign works (i've done this before) and for this one it doesn't. Why is that?
for AND clause:
Count( {<[reason is]={'this'}> * <[reason is]={'that'}>} distinct [row id])/ count([reason is])
Hi,
For the 'and' clause;
Count( {<[reason is]={'this'},[another_field]={'something'}>} distinct [row id])/ count([reason is])
or
Count( {<[reason is]={'this'}>*<[another_field]={'something'}>} distinct [row id])/ count([reason is])
Thanks a bunch 🙂