Shared filters in subqueries
8 November, 2010
We are building numerous reports which use subqueries (both append and union).
In addition to what goes on within the subqueries, the reports need to have filters which apply across the entire report, for instance to display a specified date period or only data for one branch.
All of these filters can be set up on each subquery individually, but in order for the report to be useful on a dashboard (or at all), it is necessary for the user to be able to select the filter value and have it apply to all subqueries.
Attempting to place such a report on an analytics tab which has a single filter displayed only seems to allow one of the subquery filters to reflect that shared filter, leaving all the other subqueries returning unfiltered data. I am unable to find any way to get a single query selection to apply to all subqueries in a report.
Any ideas or do I just need to abandon subqueries for any report that needs a report-wide filter?
In addition to what goes on within the subqueries, the reports need to have filters which apply across the entire report, for instance to display a specified date period or only data for one branch.
All of these filters can be set up on each subquery individually, but in order for the report to be useful on a dashboard (or at all), it is necessary for the user to be able to select the filter value and have it apply to all subqueries.
Attempting to place such a report on an analytics tab which has a single filter displayed only seems to allow one of the subquery filters to reflect that shared filter, leaving all the other subqueries returning unfiltered data. I am unable to find any way to get a single query selection to apply to all subqueries in a report.
Any ideas or do I just need to abandon subqueries for any report that needs a report-wide filter?
Hi Shaun,
With the subquery reports, you need to make sure all of the filters have been setup so that they are all linked to the filter in the master query.
You can do this on the filter selection screen (step 2 of the report builder).
Has this been setup on the report itself?
Or does this report behance differenly on the dashboard?
Regards,
David
With the subquery reports, you need to make sure all of the filters have been setup so that they are all linked to the filter in the master query.
You can do this on the filter selection screen (step 2 of the report builder).
Has this been setup on the report itself?
Or does this report behance differenly on the dashboard?
Regards,
David
Thank you, the link to filter option resolves the problem, and once the report with this in place is used on the analytic tab the filter links work correctly.