Thank you for your response, I appreciate it. You answer has helped with my overall challenge.
But I also need to be able to provide filters using the calculated fields - i.e Site Question, and Status Question filters. The way I created those means that if I select from one filter it only shows those answers, instead of all records that for Organisations that have a particular Site answer. I want to be able to filter by answers to both filters (e.g. Brisbane and Active) and make these Quick filters available to end users on Dashboards. Please see screenshot below. Thanks
1 of 1 people found this helpful
You can use a combination of parameters and filters to achieve this.
Step 1: Create a parameter [Select Question]
Step 2: Create calculated field [Question Filter]
[Question] = [Select Question]
Add this field to the filter shelf and set to 'True'.
Step 3: Create your view.
Right click on [Select Question], choose 'Show Parameter Control'
Display only relevant values for the [Answer] filter.
Hope this helps.