Question

Display the values of 4 columns in a pie chart

  • 22 July 2021
  • 1 reply
  • 13 views

Hi there,

 

I have an aggregate table where four columns are different total counts that are equivalent to the entire count for that row. I want to display the values of those 4 columns in a pie chart.  Currently I have them defined as measures of the sum type. 

 

That works well for doing stacked area graphs, but for some reason it doesn’t allow for a pie graph.  Any ideas on how to make a pie graph from the data?

 

Thank you

 
 
 
 
 

1 reply

If I have a table that looks like: 

item     | total_a | total_b | total_c--------------------------------------"car"    |  100    |  50     |  50"chair"  |   3     |  5      |  45"car"    |  50     |  100    |  100

 

How can I show that "car" has an equal 33% distribution (150 each) of total_a, total_b, and total_c?

 
 
 
 
 

Reply