Pass multiple filter values to drill through report
9 April, 2014
I created a master report (Chart) to pass multiple filters to a drill through report. One of the in list filters is Gender. In the master report, I select both Male and Female and the chart display the correct number (total number of athletes from certain country).
However, when I click on the hyperlink (Athlete Country) on the chart, the drill through report only display the Female athletes. Please refer to the attached screenshots.
However, when I click on the hyperlink (Athlete Country) on the chart, the drill through report only display the Female athletes. Please refer to the attached screenshots.
Hi,
An ordinary Column Chart can only pass 1 value to a Drill Through Report (in this case Athlete Country=Iran), the first value is selected for all other filters (in this case Demographic=Adventure and Gender=Female)
A Stacked Column Chart can pass 2 values to a Drill Through Report, this is the max values that can be passed via a Chart.
What i would suggest is using 2 of the fields as Sections, this will create Multiple Charts but it will allow all 4 values to be passed to the Drill Through Report (2 from the Section and 2 from the Chart)
Chart Example with 2 Section Filters and 2 Chart Filters
Report example with Filters passed
Hope this helps you to achieve what you are trying to do.
Regards,
Stephen
An ordinary Column Chart can only pass 1 value to a Drill Through Report (in this case Athlete Country=Iran), the first value is selected for all other filters (in this case Demographic=Adventure and Gender=Female)
A Stacked Column Chart can pass 2 values to a Drill Through Report, this is the max values that can be passed via a Chart.
What i would suggest is using 2 of the fields as Sections, this will create Multiple Charts but it will allow all 4 values to be passed to the Drill Through Report (2 from the Section and 2 from the Chart)
Chart Example with 2 Section Filters and 2 Chart Filters
Report example with Filters passed
Hope this helps you to achieve what you are trying to do.
Regards,
Stephen
Thank you for the reply, Stephen. Is that a chart (including maps) that can pass two values from the same in list filter to the drill through report? In my example, I will like to pass both "Female" and "Male" values from the Gender filter to the drill through report.
Hi,
Yes a Map can pass 2 values to a Drill Through Report.
If you remove Gender as a filter, it will return both "Male" and "Female" values.
Below is example of a Map, with 2 values (Athlete Country and Demographic)
Here is the Drill Through Report, showing both Male and Female
(I removed Gender as a filter from the Child Report)
Regards,
Stephen
Yes a Map can pass 2 values to a Drill Through Report.
If you remove Gender as a filter, it will return both "Male" and "Female" values.
Below is example of a Map, with 2 values (Athlete Country and Demographic)
Here is the Drill Through Report, showing both Male and Female
(I removed Gender as a filter from the Child Report)
Regards,
Stephen
Appreciate the clarification. Is it possible to pass two (multiple) values from a single in list filter to a drill through report? For instance, passing both Female and Male values to the drill through report.
If this is not available in the current release, will it be implemented in a future release?
If this is not available in the current release, will it be implemented in a future release?
Hi,
Apart from joining a Parent Report field to a Child Report filter, you could also join a Parent Report filter to a Child Report filter, as follows:
eg. In the below example I added Gender as a Filter on both the Parent and Child Reports and joined them using the Filter
Here i select Male only in my Filter, and the Drill Through Report returns Males only.
Here i select both Male and Female in my Filter, and the Drill Through Report also returns both Male and Female.
Hopefully this is what you are after?
Regards,
Stephen
Apart from joining a Parent Report field to a Child Report filter, you could also join a Parent Report filter to a Child Report filter, as follows:
eg. In the below example I added Gender as a Filter on both the Parent and Child Reports and joined them using the Filter
Here i select Male only in my Filter, and the Drill Through Report returns Males only.
Here i select both Male and Female in my Filter, and the Drill Through Report also returns both Male and Female.
Hopefully this is what you are after?
Regards,
Stephen
Hi,
Apart from joining a Parent Report field to a Child Report filter, you could also join a Parent Report filter to a Child Report filter, as follows:
eg. In the below example I added Gender as a Filter on both the Parent and Child Reports and joined them using the Filter
Here i select Male only in my Filter, and the Drill Through Report returns Males only.
Here i select both Male and Female in my Filter, and the Drill Through Report also returns both Male and Female.
Hopefully this is what you are after?
Regards,
Stephen
Apart from joining a Parent Report field to a Child Report filter, you could also join a Parent Report filter to a Child Report filter, as follows:
eg. In the below example I added Gender as a Filter on both the Parent and Child Reports and joined them using the Filter
Here i select Male only in my Filter, and the Drill Through Report returns Males only.
Here i select both Male and Female in my Filter, and the Drill Through Report also returns both Male and Female.
Hopefully this is what you are after?
Regards,
Stephen