Skip to main content

Interface Pie Chart

  • September 26, 2023
  • 4 replies
  • 200 views

Nathan_Ramey
Forum|alt.badge.img+9

Hello!

I am trying to create pie graph, that combines data from mutiple different fields and show them together

For example:

I want to combine that data and show that Group 1 had 61% of the score and so on. In one graph is there a way to do this?




4 replies

Forum|alt.badge.img+17
  • Inspiring
  • September 26, 2023

Is it absolutely necessary for your data to be stored in wide format like that? I wanted to do the exact same chart as you but I had to transform all my data into vertical format.

I would be very interested to know if you can make this work the way you have your fields formatted.


Nathan_Ramey
Forum|alt.badge.img+9
  • Author
  • Known Participant
  • September 28, 2023

Is it absolutely necessary for your data to be stored in wide format like that? I wanted to do the exact same chart as you but I had to transform all my data into vertical format.

I would be very interested to know if you can make this work the way you have your fields formatted.


What do you mean by Vertical format? The percentages are in three different records?


Forum|alt.badge.img+17
  • Inspiring
  • October 3, 2023

What do you mean by Vertical format? The percentages are in three different records?


Hi @Nathan_Ramey ,

Have 1 column which indicates the group number and 1 column which indicates the percent.

I realize in some cases this is sub-optimal. This is just what I had to do to get my data displayed in a pie chart. If you find away to display your data, stored the way it is currently, in a pie chart, I would really like to know,.


Forum|alt.badge.img+4
  • New Participant
  • October 17, 2023

Most likely will need to be Vertical format unless you do a formula column at the end and do =SUM() those 3 percent columns