Discussions

Expand all | Collapse all

Dynamic Reports on Pages

  • 1.  Dynamic Reports on Pages

    Posted 05-21-2020 15:52
    Here's my scenario:

    I have an app that displays information specific to different countries.

    I am using 'Home Pages' to create dashboards for each of the individual countries.

    The 4 reports/charts on every dashboard are identical except that every report/chart is filtered to only show information for that specific country.

    Before I go off creating 30+ pages and 30+ instances of each of the 4 reports/charts I wanted to see if there was a way to make the pages dynamic-  such that I still would have to create 30+ pages (I assume) but then could set something or use something at the page level to dynamically set the filter within each of the reports/charts.    

    Appreciate the help.

    Example:   

    I have an Austria Home page and a UK home page.   

    Each of those pages hold 4 reports:   Order list, orders by date, order type chart and order frequency chart

    Instead of individually creating Order List- Austria, Order List- UK, Orders by Date-Austria, Orders by Date-UK, etc, etc I wanted to see if there was a way to create just one Order List report, one Orders by Date report, etc.,etc. all filtered by X variable and then some way of setting that X variable by Page


    ------------------------------
    Jennason Quick Base Admin
    ------------------------------


  • 2.  RE: Dynamic Reports on Pages

    Posted 05-21-2020 16:06
    It would be worth you contacting me for some one-on-one assistance.

    I can show you apps where there are global filters which simultaneously filer a dozen reports on a dashboard and that is on a "per user" basis, so each user's choice of filters do not affect his buddy beside them (virtually beside them,  or at least 6 feet away beside them).  It would be about 2 -3 hours of consulting time starting with the free demo of existing apps using this same "User Focus" technique.

    So each report just needs to be built once and there is only 1 Dashboard.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Dynamic Reports on Pages

    Posted 05-21-2020 16:48
    Jennason,

    Mark helped me with this exact thing, and it's fantastic. Highly recommend contacting him, it was well worth it!

    ------------------------------
    Mike Tamoush
    ------------------------------