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.
Data example:
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
Answers
-
If you're wanting to just view it as a table you can utilize a Pivot Table card.
https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table
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
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive