Let’s assume I have the following dataset:
I want to plot a line chart with the sum of grades per subject, with the possibility of drilling by student. I also want to have two parameters, one for subject and other one for student, so I can choose what I want to see from a dropdown. The issue here is that when I am at the top level, the control filters work just fine, both relating to the visualization and to each other (if I choose Sports on the first filter, I will only be able to choose Jack, Marshall, Randy, Lily or Phil from the second one).
The problem starts when I drill down to the next level. If I drill down on sports, I will only see Jack, Marshall, Randy, Lily or Phil on the visualization, but the control filters will still have every student. Is there anyway I can filter what is on the dropdown based on the current drill on the visualization?