topic Re: Display 1 barchart per survey question with percent complete in App Development

Display 1 barchart per survey question with percent complete

RogerG — Wed, 20 Apr 2022 21:40:13 GMT

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

Re: Display 1 barchart per survey question with percent complete

RogerG — Wed, 20 Apr 2022 21:55:32 GMT

I have another catch, the answers are not the same per question, attached is a modified app

Re: Display 1 barchart per survey question with percent complete

rwunderlich — Thu, 21 Apr 2022 00:18:15 GMT

I think I would use a barchart with trellising. See attached.

-Rob

Re: Display 1 barchart per survey question with percent complete

RogerG — Thu, 21 Apr 2022 01:56:55 GMT

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

Re: Display 1 barchart per survey question with percent complete

Shalom — Thu, 21 Apr 2022 03:21:15 GMT

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

Re: Display 1 barchart per survey question with percent complete

rwunderlich — Thu, 21 Apr 2022 03:55:09 GMT

It appears that Trellis forces each chart to have symmetric dimension values. So not a good solution in your case.

-Rob

Re: Display 1 barchart per survey question with percent complete

RogerG — Thu, 21 Apr 2022 13:06:43 GMT

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.

Re: Display 1 barchart per survey question with percent complete

RogerG — Thu, 21 Apr 2022 13:28:02 GMT

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