Discussions

Expand all | Collapse all

Is it possible to open a specific report when clicking on a chart section?

  • 1.  Is it possible to open a specific report when clicking on a chart section?

    Posted 01-06-2015 09:31

    Currently, when users click on a section of a pie chart, they are taken to a line item report in the underlying table. The problem is that this report shows all of the default columns for that table. I want this report to show only specific columns (about 6 columns of the 22 that are default). Is this possible?

    Thanks in advance.



  • 2.  RE: Is it possible to open a specific report when clicking on a chart section?

    Posted 01-14-2015 18:25
    Hi Juan,

    Thanks for posting at the Community! Unfortunately, it's not currently possible to specify a different report to use when clicking through charts or summary reports.

    I suggest adding that request at https://quickbase.uservoice.com because that's the site our developers use to determine potential customer impact of new features, so if they see a number of customers would use that feature, it's more likely to get implemented down the road.

    Thanks,
    Gene Bixler

    QuickBase Care Team


  • 3.  RE: Is it possible to open a specific report when clicking on a chart section?

    Posted 07-06-2016 19:16
    It is now possible to set a report to "drill down" into when clicking on a chart, summary report or summary field! For a report, you can find this option towards the bottom of the report settings, and for a summary field, you can find this option on the properties of the summary field.


  • 4.  RE: Is it possible to open a specific report when clicking on a chart section?

    Posted 02-08-2017 18:13
    How, exactly, does one get this to work? I have a summary report (with grouped columns, if that makes any difference) and have defined a report to drill down into. When clicking on a value to drill down into, I get no results displayed. When I go immediately into the drill down report's filters, I see that the original filters are duplicated and a new set if filters has been added. 

    Is there some trick to creating the drill down reports? 


  • 5.  RE: Is it possible to open a specific report when clicking on a chart section?

    Posted 02-09-2017 02:50
    The drilldown report will use the filters from the parent/master report in addition to any existing filters on the selected drilldown report.

    You will want to make a "drilldown" report with the styling and columns you want, BUT make sure there are zero filters applied.

    Then make that report the drilldown, when clicked, from a graph for example, it will apply those new filters from the parent report. 

    Let me know if you get stuck.


  • 6.  RE: Is it possible to open a specific report when clicking on a chart section?

    Posted 02-10-2017 16:01
    Thanks, Matthew. I saw the feature on the release notes but never found any detailed instructions.

    What you posted works perfectly for my summary reports that don't require user's to select criteria before hand (such as a date range or category or whatever). Thanks you again for your help.

    I'm still running into the issue I mentioned above, though, with any summary report that has user inputted criteria. Would you have any insight on that?


  • 7.  RE: Is it possible to open a specific report when clicking on a chart section?

    Posted 02-10-2017 17:43
    I did a quick test on one of my summary reports that has some grouping, and the drill-down worked as it should have.  
    I even applied a "Ask the user" filter for the master summary.  
    I'm note sure what might be causing the data discrepancy.

    Maybe, if its ok, take some screen shots and show/explain whats happening.  


  • 8.  RE: Is it possible to open a specific report when clicking on a chart section?

    Posted 05-10-2017 15:15
    This works for a Summary Report, but what about a Table Report that has "Show summary table based on the grouped columns" and "Hide main table and show only summary table" checked? It doesn't look like it's possible to specify a drilldown report in this case.

    I would at least expect the drilldown in this case to show a details report with the same columns as the original Table Report...

    Thanks,
    Bobby