I need to prepare a bunch of reports for executives as part of a quarterly meeting. They are built but require various dynamic filters and the ability to be compiled to one area vs execs searching for multiple reports. Any way to do this or best practices others are using?Each report also has some different views based on who gets it so it's not even five of the same. Real pain manually.------------------------------Ivan Weiss------------------------------

My typical implementation starts with a single record ID# 1 on the single record single record on the Dashboard.It is connected to all Users in the Users table. The purpose is simply to auto create the user if they do not exist ad in this case i land the user on the user focus record where they make their selections for their Focus. if you somehow know that you have Users created in this table then you don't need this step.//Edit or Create a User Record for the Current User (remember to set permissions in the //User focus table)//Set Key Field of user foicus table to userid//User Exists - true!//Remember to set permissionsvar text AddUser = URLRoot() & "db/" & [_DBID_USER_FOCUS] & "?act=API_AddRecord"& "&apptoken=b6rmtc2cyphwcvd4x6ur8cr3d6rd" & "&_fid_6=" & ToText(User()); var text EditUser = URLRoot() & "db/" & [_DBID_USER_FOCUS] & "?a=er"& "&apptoken=b6rmtc2cyphwcvd4x6ur8cr3d6rd"& "&key=" & ToText(User());var text DisplaySelectDateForm = URLRoot() & "db/" & [_DBID_USER_FOCUS] & "?a=er&key=" & ToText(User())& "&dfid=10";var text CompareDashboard = URLRoot() & "db/" & AppID() & "?a=showpage&pageid=3";If([# of User Focus Records for the Current User]=1, $DisplaySelectDateForm& "&NEXTURL=" & URLEncode($CompareDashboard),$AddUser& "&rdr=" & URLEncode($DisplaySelectDateForm)& URLEncode("&NextURL=" & URLEncode($CompareDashboard)))But then the magic is that because the Key field is User, that means that i can have a relationship to any other tables using a field called [Current User] with a formula of User() to look up my Focus values - say Record ID# of Focus Project.Then filter all Dashboard reports where [Record ID] of the project = Record ID# of Focus Project.Depending on the user case one could also launch off a report of all project to set the user focus with an API to either Edit or create the Userid with that Focus and ten land the user say on a dashboard with a whole set of reports pertinent to the Focus Project.Of course in a different use case, maybe the Focus is on a Sales Branch or a Product Category or both, to then have a whole standard set of dashboard reports filtered on some branch(es) and some Product Categories. So the sales manager might want to see everything for their own Branch, and the Product Manager may want the filter for all Branches but just their own product categories.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Would it be a solution if you could have a dashboard full of a whole bunch of reports and be able to globally apply the same filters to that set of reports all at once?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

That could work. But I guess the question is the group of reports are all coming from different tables. The filter is the same though and it is a user based filter. So the question is, could you do that? I think one dashboard page with 9 reports on it is a bit tough to read (I prefer one report per page and a multi page report) but to save myself from this manual screenshot game I am playing I would go with it.------------------------------Ivan Weiss------------------------------

There is a way to do this, and all native, and the technique can work across multiple tables. But I think we would need to do this together on a Go To Meeting screen sharing session. Contact me off line if you would like one on one assistance setting this up.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Eloyse Ellerman shared an app on the exchange that utilizes a filtered report on a dashboard to apply the filter selection to all of the reports on the dashboard and only show data for the current user. Here is a link:Dynamic DashboardShe starts with three related tables, a circular relationship between departments and filters and one department to many activities: The filters table is a list of users associated to departments: She creates a 'User Filter' summary field in the one departments to many filters relationship: She sets the proxy field to department and only summarizes data where user is current user: Then she add the 'User Filter' field as a lookup in the one filter to many departments relationship: Next she does a lookup on the lookup in the one departments to many activities relationship:Finally she applies filters to the dashboard reports where department is equal to the value in the lookup of the lookup: IIt's pretty slick. You might be able to use this for your needs allowing the Exec's to just navigate to a dashboard and see what they need to see with little additional effort. ------------------------------Adam Keever------------------------------

Preparing Quarterly Reports for Executives

MarkShnier__You
Qrew Legend
6 years ago
Would it be a solution if you could have a dashboard full of a whole bunch of reports and be able to globally apply the same filters to that set of reports all at once?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- IvanWeiss
  Qrew Captain
  6 years ago
  That could work. But I guess the question is the group of reports are all coming from different tables. The filter is the same though and it is a user based filter. So the question is, could you do that? I think one dashboard page with 9 reports on it is a bit tough to read (I prefer one report per page and a multi page report) but to save myself from this manual screenshot game I am playing I would go with it.
  
  ------------------------------
  Ivan Weiss
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    6 years ago
    There is a way to do this, and all native, and the technique can work across multiple tables. But I think we would need to do this together on a Go To Meeting screen sharing session. Contact me off line if you would like one on one assistance setting this up.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
AdamKeever1
Qrew Commander
6 years ago
Eloyse Ellerman shared an app on the exchange that utilizes a filtered report on a dashboard to apply the filter selection to all of the reports on the dashboard and only show data for the current user. Here is a link:

Dynamic Dashboard

She starts with three related tables, a circular relationship between departments and filters and one department to many activities:

The filters table is a list of users associated to departments:

She creates a 'User Filter' summary field in the one departments to many filters relationship:

She sets the proxy field to department and only summarizes data where user is current user:

Then she add the 'User Filter' field as a lookup in the one filter to many departments relationship:

Next she does a lookup on the lookup in the one departments to many activities relationship:

Finally she applies filters to the dashboard reports where department is equal to the value in the lookup of the lookup:

IIt's pretty slick. You might be able to use this for your needs allowing the Exec's to just navigate to a dashboard and see what they need to see with little additional effort.

------------------------------
Adam Keever
------------------------------
- IvanWeiss
  Qrew Captain
  6 years ago
  Thanks Mark and Adam for the answers! Going to play with this a bit to see if it can work.
  
  I think I need to fix one other thing I built early on in the app preventing this idea from working right. But its a pain now for a long term fix so worth the effort. I also saw a video from Kirk about this type of thing so it looks like filtered dashboards is not such a big deal, phew!
  
  ------------------------------
  Ivan Weiss
  ------------------------------
  - AdamKeever1
    Qrew Commander
    6 years ago
    Check out this video by Kirk Trachy:
    
    Dynamic Executive Dashboard
    
    ------------------------------
    Adam Keever
    ------------------------------

Forum Discussion

Preparing Quarterly Reports for Executives

Related Content

Preparing for Automations End of Support on June 30, 2022

Error - Invalid record data provided when executing form rules

Filter Monthly, Quarterly, Yearly from one Date field

Pipeline error: Formula Query Execution took too long

Order of execution