I would like to use the interactive dashboard to filter my main dashboard by school name. I have 2 tables
Main = Key = Student ID, Label = Student ID
Schools = Key = School Name, Label = School Name, Ref = School Name Ref
I want to filter my main dashboard by school and I have tried so many things. I have tried the enhanced dashboard method from YouTube and didn't work, I like this method posted Here But I think I am missing something. Can someone explain it as to what I need for the source and what I need for the control and how to I link those 2 for my main table dashboard to filter? Do I need to make the main table key the same and the schools table? Can I just use the school name field thats already on main?
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |