I’m trying to set an action for my dashboard to make the data displayed dependent on the relevant filter selection. Data source has 2 relevant columns(Course Title, Course Name) for two groups of the same students: 1. All students who took the class can be filtered by (Course Title). B. Of those who took a class, those who completed course evaluations can be filtered by (Course Name). Some sheets on the dashboard display accurately when I have set actions to work with the Course Title filter. But this unsurprisingly makes other sheets inaccurate, eg, a sheet showing how many students liked the course (which should be dependent on those who completed the course evaluation) and therefore Course Name filter. I wonder if I can set actions to have it that those sheets that depend on students who took the course evaluation display data only from the Course Name filter (even though actions are set to the Course Title filter?) and then have the other sheets that align with the Course Name filter also stay accurate. So essentially, I want a dashboard action that picks either filter depending on the sheet being displayed on the dashboard. Anyone know a workaround?
0 Answers
Related