Forum Discussion

JuanSolorio1's avatar
JuanSolorio1
Qrew Cadet
11 years ago

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

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...
reports and charts
Tables and fields
User and group management
ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago
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.
ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago
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?