Pie Chart - Combine Values

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered

Hello all,

I tried to search for what I'm trying to do but I didn't know how to word it exactly. I would like to create a pie chart but combine values. In other words, my data looks something like this:

  1. Piano: 10
  2. Banjo: 1
  3. Flute: 1
  4. Guitar: 3
  5. Sitar: 2

If I make a pie chart right now, it will show me:

  1. Piano: 59%
  2. Banjo: 6%
  3. Flute: 6%
  4. Guitar: 17%
  5. Sitar: 12%

As expected. However, I'd like to somehow combine the values, so the output looks more like this:

  1. Piano: 59%
  2. Other: 41%

I considered making a calculated column somehow but I didn't know what to put in it: If([Instrument]="Piano",........?)

Could someone please help me out?

Photo of Anna Gramme

Anna Gramme

  • 2 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
If ([Instrument] = "Piano", "Piano", "Other")
Photo of Anna Gramme

Anna Gramme

  • 2 Points
This seems to solve the calculated column problem, but how can I use this as the series in my pie chart?
Photo of Keith

Keith

  • 0 Points
If you set that calculated column as your series you should get what you're looking for, because it will either say Piano or Other, so you'll get your two pie slices.
Photo of Anna Gramme

Anna Gramme

  • 2 Points
I think I'm still missing something. When I'm on the screen to create my chart, in the "Chart Details" section, I can't set the Series to the calculated column. I don't see something that says <Calculated Column> or the label I gave it. All I see are the current fields available. I see the <Calculated Column> in the Data values, but I need that to be the series. Maybe I'm trying to do this in the wrong table?
Photo of Keith

Keith

  • 0 Points
Oh, i could see how that could be the case. If you create a new field, Formula - Text, and use that formula, then you will have that field available for the report.
Photo of Anna Gramme

Anna Gramme

  • 2 Points
Ah; perfect! Thank you!
Photo of Manolo

Manolo

  • 214 Points 100 badge 2x thumb
Hello,

I have a pie chart with too many values in "customer" field, how can I combine values so that all customers that fall below 4% participation will be put together.

can someone help with the formula?

thank you