Keeping the filtering function of current selection while disregard it in count function

[#1]

Dear all,

I have encountered the following problem.

I have made 2 straight table in a dashboard.

Suppose the first table consists of the information for students, while the second table consists of the information of interest club in school. Since one student can belong to several interest club, I expected that when I click on one student, the second table will shows the interest group the student belong to. The problem is, there is a column displaying the total number of students in that interest club and when I click on the student, the number will become 1 as expected. I have tried to use count({} distinct student) and it can fix the problem of number of count. However, the filtering function is also disabled. That is, now the second table (the interest club) will show all the interest club instead of the interest club that the selected student belong to.

Would you please advise?

Message was edited by: ivy ting

[morganaaron]

See attached for what I was mentioning before. Just change the data I loaded for your existing data and alter the resident load to look at student_no and it should work!

[ashfaq_haseeb]

Hi,

Check if this helps

Regards

ASHFAQ

[rubenmarin]

Hi, check attachment if this meets your requirements.

[Anonymous]

Hi,

Ruben's method should work. I if you are looking for the same.

[#6]

Thanks a lot! it works. Would you please explain a bit what is the mechanism behind the following expression? count({0"}, student_no>} DISTINCT student_no)

[rubenmarin]

The filters are in set analisys:

count({<club={"=Count(student_no)>0"}, student_no>} DISTINCT student_no)

club={"=Count(student_no)>0"} filters the field 'club' to show only the clubs wich have at least one of the selected students

student_no ignores the selection in student_no, so the count will count all the students in each club