Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1:
Field A | Field B |
---|---|
A | 10 |
B | 20 |
C | 30 |
D | 50 |
Table 2:
Field C | Field D |
---|---|
A | 1 |
B | 2 |
D | 3 |
E | 4 |
How to set an analysis like below where Table 1 and Table 2 are not associated together?
Count (distinct (if(Field B > 0 and (Field A exist in Field C), [Field B])))
Many Thx!
That is strange because not having anything there is equivalent of having $ (unless you chart is in an alternate state). So essentially these two equations are the same
Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])
Count(DISTINCT {$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])
May be this:
Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])
Hi Sunny,
it seems not work.
Does It only allows putting value in P(Value) instead of P(Field)?
Best Regards
It works after adding the $
Count(DISTINCT {$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])
THX!
That is strange because not having anything there is equivalent of having $ (unless you chart is in an alternate state). So essentially these two equations are the same
Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])
Count(DISTINCT {$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])