topic Re: Set Analysis w/Variables - show one value in a list in App Development

Set Analysis w/Variables - show one value in a list

ccifaldi — Tue, 23 Aug 2022 19:00:12 GMT

Hello! I am using set analysis with variables to create dynamic bar charts. Users should be able to select a question from a filter list and then see a bar chart that contains percentages per each response option. In my example there are 4 options to choose from: North America, EMEA, Asia-Pacific and Latin & South America. I have successfully used variables on the question and list of all responses part. I am stuck on how to limit each bar to one response. Attached are images.

Desired End Result:

Set analysis:

Dim/Mea:

Re: Set Analysis w/Variables - show one value in a list

Digvijay_Singh — Wed, 24 Aug 2022 03:44:51 GMT

Not able to understand completely, please share your current chart to understand more about the problem.

Re: Set Analysis w/Variables - show one value in a list

ccifaldi — Wed, 24 Aug 2022 12:19:43 GMT

Hello! How should I post that for you? .qvd?

Re: Set Analysis w/Variables - show one value in a list

SunilChauhan — Wed, 24 Aug 2022 12:31:48 GMT

Better share some sample Data , as requiredment not clear . Need more info to work

Re: Set Analysis w/Variables - show one value in a list

ccifaldi — Wed, 24 Aug 2022 15:05:38 GMT

Thank you! Here is a sample of the raw data. There are two columns "Question" and "Response". What I would like to do is have variables working to create the charts because we have thousands of questions and their related responses in our actual dataset. The idea is to allow users to log on to one sheet in an app and select one question at a time and have the graph dynamically work. I can do this in a rudimentary way, but, we need to apply custom filters and eventually create year over year and stacked bar charts with our data that are dynamic.