report for open answers survey question with possibility to filter on CSAT question
We have created a report that shows us the open answer to our survey (see definition attached). However, we want to be able to filter the results on the results on our CSAT question (to be able for example to filter on "very satisfied" and inform the agents about the compliments. I am not able to add a filter to the report which enables me to filter.
I used the question_choices.choice_ID field as a filter. I had to join the table to eiter the questions or the question_responses tabel. I tried both, inner and outer join but I get no result. I have no clue what is going wrong, so I hope maybe someone here can help me out.