Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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)
sample app
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.
Hi, Sorry i'm on vacation
If you open a separate thread, someone will surely assist you