Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 26, 2023 10:54 AM
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?
Sep 26, 2023 03:53 PM
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.
Sep 28, 2023 04:10 AM
What do you mean by Vertical format? The percentages are in three different records?
Oct 03, 2023 08:20 AM
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,.
Oct 17, 2023 08:17 AM
Most likely will need to be Vertical format unless you do a formula column at the end and do =SUM() those 3 percent columns