Changing the chart type dynamically based on the data
- I have a dataset the contains the results of multiple different surveys with 10 to 20 questions.
- The response to the survey questions can be a star rating, single select, multiple select, or freeform text.
- The type of response is a column in my dataset.
- Each survey can have their own order of response type. i.e.,
- In survey Test1, the first question is a rating response
- In survey Test2, the first question is a freeform text response
- The dashboard is limited to show one survey at a time
- I want to display a card by question in the order the questions appear in the survey
- How do I dynamically change the card from a stacked bar graph when it is a rating response to a table when it is a freeform text response.
Best Answer
-
You could potentially do this using Domo bricks. It's going to require a fair amount of Javascript and the Phoenix chart libraries to switch it based on your different types. If you aren't skilled in Javascript, it's going to be quite challenging.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
I don't think Domo has a built-in feature for automatically changing the chart type. You can simulate the behavior using filters, multiple cards, and structuring your dataset. You should be able to do something like this:
- Creating a Response Type column that categorizes each survey question.
- Use multiple cards (or multiple views within one card) based on the response type.
- Applying filters to control which chart is displayed, based on the selected survey/question response type.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Thanks. That is our current approach. However, I am being challenged to come up with a more elegant approach for our customers.
0 -
You could potentially do this using Domo bricks. It's going to require a fair amount of Javascript and the Phoenix chart libraries to switch it based on your different types. If you aren't skilled in Javascript, it's going to be quite challenging.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thanks for the suggestion. I will investigate that approach.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive