Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello guys,
I am looking to create a pie chart from the values below. The graph should look like this:
first value should be sum of Attribute A (for all owners) / sum of total items
second value should be sum of Attribute B / sum of total items
the last value should be sum of items without any attributes / sum of total items (e.g. for owner A it is 12 -3 = 9)
Owner | Total_Items | Attribute_A | Attribute_B |
A | 12 | 3 | 0 |
B | 10 | 1 | 5 |
C | 8 | 4 | 0 |
D | 6 | 2 | 1 |
Please advise on how to set the dimension and expression. I am a beginner obviously 🙂
Use no dimension, and three expressions in your pie chart.
can you explain or the output from :
"the last value should be sum of items without any attributes / sum of total items (e.g. for owner A it is 12 -3 = 9)"
hello,
the output graph should look like this:
Attribute A = sum of column Attribute_A
Attribute B=sum of column Attribute_B
No Attribute=sum of column Items - sum of column Attribute_A - sum of column Attribute_B
Use no dimension, and three expressions in your pie chart.
it works!! thank you!