Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Thanks to @rwunderlich first for this example. however I am looking to display one barchart per question, with it's associated Percentage of the response for that question.
I have tried to change the Expression for Set Analysis, but failed, I have tried to modify the dimension to a calculated dimension of Question = "Q1" no luck
any assistance is appreciated.
Thanks
I have another catch, the answers are not the same per question, attached is a modified app
I think I would use a barchart with trellising. See attached.
-Rob
I really like this solution, but is there a way to not show values on the graph which don't pertain to the particular question? My issue is I have questions with a variety of answers.
so these should not be there
Hello RogerG,
You can try if loop for Q1 in the calculated dimension as below:
=if(Question = 'Q1', Question)
Similarly you can have a bar chart for each question.
Thanks & Regards
Shalom Daniel
It appears that Trellis forces each chart to have symmetric dimension values. So not a good solution in your case.
-Rob
I did try a separate barchart for each one, however I could not get the data to segregate unless I pivot the data. I didn't want to do that because I want to select an answer and see all the questions related to that answer.
The separate barcharts was my original idea, but I could not get it to separate or calculate properly
I am not an expert developer 🙂
Thanks