Grouping multiple values into a category
Hello,
I think this should be relatively easy but I cant seem to work out how its done.
I am trying to group a number of 'values' so that I can see them on a pie chart.
eg. Imagine the following table
column header 1 column header 2 column header 3
5 6 7
6 4 13
3 7 4
I want a pie chart that shows column header 1 - 25%, column header 2 - 31% and column header 3 - 44% but because a pie won't allow multiple values I am struggling to make this happen.
Any help is appreciated
Comments
-
@andrewh Good question. I was trying to work through this for you and I came up with a quick solution which may not satisfy you but it might work for you.
If you use the "100% Stacked Bar" chart inside the Domo card builder then select your multiple value columns (which you have) as your y-axis and different series then it works, however, you do need an x-axis... If you have a date column that works, or if you could throw in some string text into every row of your table into another column then you could build the card out using that as your x-axis. As far as my knowledge goes, you cannot add multiple value columns to a pie chart. Let me know if you have questions.
See my example below:
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"1 -
This is a good example of where data could need to be transposed or pivoted before you can get all the use out of it you'd like. That means taking your data like this:
column header 1 column header 2 column header 3
5 6 7
6 4 13
3 7 4
And pivoting it to look like this:
Value Series
5 column header 1
6 column header 1
3 column header 1
6 column header 2
4 column header 2
7 column header 2
7 column header 3
13 column header 3
4 column header 3This is often done using a Dataflow with a transform that looks something like this:
SELECT `column header 1` AS `Value`, 'column header 1' AS `Series`
UNION
SELECT `column header 2` AS `Value`, 'column header 2' AS `Series`
UNION
SELECT `column header 3` AS `Value`, 'column header 3' AS `Series`
(Note that for the Value we are using the record's value from the "column header X" field and for the Series we are using text that describes the category for the value.)
After the data has been pivoted, the pie chart would build out very easily. It's just hard to use summary or tabular data to build out many types of cards.
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive