Can you Insert multiple X-Axis?
I'm attempting to build a new chart where there are multiple columns with a single value for an individual. I know this isn't an optimal data set, and I've reworked it for another dashboard, but I would like to keep it in this format if possible. I believe other data visualization tools allow you to add multiple x/y-axis but I can't find a way to do this in Domo.
Person Name Question 1 Question 2 Question 3 Question 4
John 1 3 7 2
Erik 4 2 6 5
I want to be able to drop each question as a value on the X-axis, so that I can track the value o each question by each person or the total/average of each question by all people.
The reason I want this data structured in this way is because I want a single row per person in my data set. I want to attach this data to another set of data I have that's already about 100 columns and I don't want any duplicate rows.
I've already reworked this data as follows, but I need the about format for a separate dashboard:
Name Question Value
John Q1 1
John Q2 3
John Q3 7
If you're wanting to just view it as a table you can utilize a Pivot Table card.
You can set the name as the rows and the question as the columns with your value as the value.**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Unfortunately, I don't need it in a table form. I already have it available in a table. I'm trying to join it to an existing table that is just 1 row per person.
The end goal is to add this question data to a current dashboard that can be filtered using the same data set. That way I could simultaneously look at something like Count of all people and Average score of all questions.
If I try to use the second table I built, using Count on the People column would not be accurate because each person would have a row per question. I could technically create a different chart for every question, but there are 50+ questions and it would not be very aesthetically pleasing or user friendly.0
You might want to look at using the Trellis properties for your chart. That provides a form of multiple x-axis functionality.
https://domohelp.domo.com/hc/en-us/articles/360043429793-Properties-Available-for-Most-Charts#8.**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. Unfortunately, this didn't quite work out how I had hoped and was instead giving numerical values along the X-axes instead of the category names.
At this point, I don't think that the table is built in a way that can support the type of visualization I'm looking for. I'll likely have to build 2 separate dashboards and potentially use this table to cross reference data if necessary.
I appreciate the input, everyone.0
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 82 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 178 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive