Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone.
I would like to create a Pie Chart with 7 dimensions:
GDP per capita | Social support | Healthy life expectancy | Freedom to make life choices | Generosity | Perceptions of corruption | Dystopia |
1.34 | 1.587 | 0.986 | 0.596 | 0.153 | 0.393 | 2.714 |
These dimensions "GDP per capita" , "Social support", "Healthy life expectancy","Freedom to make life choices", "Generosity","Perceptions of corruption" and "Dystopia" add up to a score, in this case
Score |
7.769 |
The pie chart must represent the score with its parts representing the dimensions.
Combining the dimensions (GDP per capita&Social support&...) to one dimension and setting the score as Measure did not work. Is there a way to solve this?
Thanks in advance!
hi
what you should try to do
is in the load script run a crosstable function so in the end the Table will look like this
than building the chart would be easy
Thanks for your reply, it worked!