This content has been marked as final. Show 3 replies
I am attempting to present the results of multiple surveys within a chart. Each survey has a number of questions which I am trying to group within a trellis. Each question has n number of unique options. However the chart is rendering all possible options not just the options that apply to the current question.
I have attached an example report containing 4 inline tables that mirror my database schema. The dimensions for the chart are Question Text, Answer Text and the expression is the distinct count of Sequence Id.
Is it possible to only display the option text axis that apply to the question? If you select an individual question the results are as expected, i.e only applicable answers are displayed.