Applying Not In for multiple Tables

[berryandcherry6]

Hi,

i have 3 tables

Table1:   

UserID	CourseCompleted	ADClicked
34	1	1
43	1	0
45	1	1
46	0	0
47	0	0
48	1	0

//above table contains  CourseCompleted and Not CourseCompleted Users

Table2:   

DownloadID	UserID	downloaded
23	34	0
24	43	0
25	45	2
28	48	3

//above table contains only CourseCompleted Users

Table3:

UserID	typeID
34	7
43	23
45	23
46	23
47	23
48	6
45	5
46	4
48	23

//above table contains  CourseCompleted and Not CourseCompleted Users

Here i Need to get below Counts:

1.) Count of ADClicked by CourseCompleted users only.

2.) Count of downloaded by CourseCompleted users only.

3.) Count of CourseCompleted users only who has typeID = 23.

4.) Count of CourseCompleted users who has not involved in any of above actions .

[vinieme12 · Accepted solution]

ok, just checked you app  <<MODIFIED>>

here you go

=count({<

UserID -= {"=sum({1<CourseCompleted={1}>}ADClicked)>0"}>

*

<UserID -= {"=sum({<CourseCompleted={1}>}downloaded)"}>

*

<UserID -= {"=count({<CourseCompleted={1},typeID={23}>} DISTINCT UserID)"}

>}

distinct UserID)

[vinieme12]

sample app

[berryandcherry6]

Hi Vineeth,

Sorry for delay Response. 

It works and getting correct output.

See attached App of slightly different Requirement, i am applying same logic over here, But get wrong output.

I should get 22 in NO action.  But displays 2.

[vinieme12]

Hi, Sorry i'm on vacation

If you open a separate thread, someone will surely assist you