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! **

Categories