# 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

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

• domo

💎

@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.

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:

5                               6                            7

6                               4                           13

3                               7                            4

And pivoting it to look like this:

Value                   Series

This is often done using a Dataflow with a transform that looks something like this:

UNION

UNION