How to create a Global Filter that will filter all reports and charts in one Home Page.
I have a dashboard with multiple charts and reports coming from different source tables. I want a Global Filter that will filter all charts and reports on click.
Forum Discussion
Mark
I am trying to do the same thing and not sure of the relationship, is it parent table has many program names or program name has many installations
I am trying to do the same thing and not sure of the relationship, is it parent table has many program names or program name has many installations
Assuming you were doing this in a single user environment, where you don�t expect to have multiple users tripping over each other, you create a new table for your global filter and you put exactly one record in it. They will only ever be what record in it and it will be record ID number one. Then you make a relationship to all other detail tables that you need to control. On the reference side of that relationship you will have a formula feel that calculates to one.
Then you look up the global filter down into any of the detail tables and use it in reports that are on the dashboard.
If you want to have this working in a multi user environment where multiple users can each independently set their own filters then that set up is a little more complicated and I suggest you contact me off-line at QuickBaseCoach.com.
Then you look up the global filter down into any of the detail tables and use it in reports that are on the dashboard.
If you want to have this working in a multi user environment where multiple users can each independently set their own filters then that set up is a little more complicated and I suggest you contact me off-line at QuickBaseCoach.com.