how to create a graph with 2 x-axis

Hi Domo peeps -
I just want to ask, is there a way where we can show in a grouped graph 2 x-axis?
I would like to show 2 names in the X axis, namely the Owner and PE names
and in the Y axis the Sat Score and PE Sat score respectivley.
I can show the Sat score and PE Sat Score using the grouped bar graph
but it only shows the owner for the X axis.
I have attached the raw data I have in the dataset in DOMO
Comments
-
It may help to understand the relationship between the Owner and the PE. It looks like the same owner can have multiple PE's and one PE can have multiple Owners.
Does the PE Sat score reflect on both the PE and the owner? If not, I would recommend structuring your data a little differently:
Basically, you want to have a row for Type, Name, and Sat score.
You should then be able to graph with a single bar. Name on the x axis, score on the y axis and the series would be type.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Hi ST_-Superman-_ -
basically, the row is the relationship. the Owner has his Score, and the PE has his own.
I attached a sample view of what I want to see in DOMO.
0 -
Would creating a new field for name work for you? I basically created the following beastmode:
concat(`Owner`,' | ',case when `PE`='' then 'None' when `PE` is null then 'None' else `PE` end)
This let me generate a chart like this:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
this actually looked promising. But unfortunately, the draw back is, we couldn't average the scores per person.
0
Categories
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 464 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive