topic Re: How to set Analysis with Field value exist in other column? in App Development

How to set Analysis with Field value exist in other column?

Anonymous — Fri, 28 Oct 2016 09:43:21 GMT

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!

Re: How to set Analysis with Field value exist in other column?

sunny_talwar — Fri, 28 Oct 2016 16:19:45 GMT

May be this:

Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

Re: How to set Analysis with Field value exist in other column?

Anonymous — Mon, 31 Oct 2016 01:49:55 GMT

Hi Sunny,

it seems not work.

Does It only allows putting value in P(Value) instead of P(Field)?

Best Regards

Re: How to set Analysis with Field value exist in other column?

Anonymous — Mon, 31 Oct 2016 07:08:58 GMT

It works after adding the $

Count(DISTINCT {$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

THX!

Re: How to set Analysis with Field value exist in other column?

sunny_talwar — Mon, 31 Oct 2016 20:43:10 GMT

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])