Seeking advice on my chart of MCQ responses

andyhicken
andyhicken Member
in Charting

I have a dataset that gives respondents' selections in response to multiple-choice questions on a survey tool. There's no limit on the number of questions on a survey, the length of question or response option text, or the number of options that can be defined for each multiple-choice question. The audience consuming this chart is administrators of the survey tool.

My current solution is using the Nested Bars chart type. It works pretty well (though not perfectly, to my mind) if the user filters down to one survey that has only a few questions on it. If they select all the surveys, it gets real small. See the two screenshots below.

image.png image.png

Some of my qualms with my solution here:

  • To see what options are most popular for a given question, the user has to mouse over the bar (which might be really small) or try to match it to the color in the key - and the key gets long really fast. I wish I could have big thick bars with part of the text superimposed on it (or next to it for small bars).
  • The user has to figure out that they should filter the data down to see a legible chart. I'd rather start with nothing displayed on the chart and instruct the user to select a survey to get started.
  • The bars get thin instead of scrolling or paginating. I think I'd rather have a scroll bar.

Do any generous souls out there have any suggestions to improve this thing? Thanks in advance.

Andy

Answers

  • ArborRose
    ArborRose Coach

    Interesting - a chart of survey responses that appear to be asking about AI. Um….how about using AI?

    If you haven't been viewing the sessions…on the black ribbon bar just below the main menu up top of this browser page, under the heading Community Forums, there is a link to past "event recordings". The Community Forum has been hosting AI Academy instructionals to show us examples of AI use.

    I used to handle the data for a school district of 60k students. And I handled the anonymized survey data that came back. Boy, would I have enjoyed applying AI to that stuff. Point the AI Agent at the dataset and post a form to the user. They ask the questions and the AI will answer based on the survey data. This type of application is where AI excels. The how-to is basically in the event recordings.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • andyhicken
    andyhicken Member
    https://community-forums.domo.com/main/discussion/comment/101730#Comment_101730

    Hard agree! I have been attending the sessions and I do aspire to use an AI workflow with this data.

    Follow-up question on that: is the form users use for questions limited to the Domo Webform connector? Or is there a way now to put an input directly on a dashboard and pipe that through to the AI for a real-time response? (Other than exposing the general AI Chat tool.)

  • andyhicken
    andyhicken Member
    edited May 14

    Is there a way to create a card where each question gets its own separate bar chart - so essentially a "chart of charts" that groups by the question ID and then creates a bar chart for each question with (say) the question prompt as the title, the response option text on the x-axis and the frequency selected on the y-axis?

  • ArborRose
    ArborRose Coach

    Those are a bunch of questions that should probably go to the AI Academy presenters or post in a specific thread.

    I'll say this - my mother said, "you can do anything". Mom wouldn't lie. There's always a way or a work-around. Forms can be done in workflow, pro-code, etc. And they can all interact. I came back from Domopalooza and wrote a pro-code app that has its own form and uses AI in the code and in a workflow.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • DavidChurchman
    DavidChurchman Coach

    IMO ideally you should not use to color to encode a variable with more than 5-6 options, and even in your 8 question example, it looks like you have around 20ish response choices? To give good feedback, it would be helpful to know what you want the user to get out of this chart. I'll give some suggestions based on what you want them to know, and what you could try:

    Some potential approaches:

    • Know: Readers read every question and every option for ever question, and see how many people answered that option
      • Try: You could add a single-select filter card and a single-select quick-filter so that a viewer only looks at one question at a time. That might be ideal, because it would be hard to process this much text.
    • Know: readers know which options had the most responses for each question.
      • Try: from your sample, the highest number of responses was 2? Adding a filter for 2+ would simplify this chart a lot.
    • Know: which answer choices were selected across multiple questions
      • Try: a facet bar or heat map, that places questions on one axis and answer choices on the other, maybe with some filtering
    • Know: Is this a test with correct answers? It looks like maybe yes? If so:
      • Make your series correct/incorrect and do 100% bars. Then a tool tip with the correct answer and most frequent incorrect answers for labeling or on hover

    If you could give some details on the story you're trying to tell or surface with this data, there might be some other suggestions. Also, posting a sample dataset helps a lot, too

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories