Forum Discussion
Pie Chart Data
First, you need to transform your data:
Go to Edit Query, Select all the columns and Go to Transform - Unpivot Columns
Change the name of columns like you want.
Close & Apply
Create a Chart
Legend-Answer
Details-Type
Values-Count of Answer
Other alternative Chart
Legend-Type
Details-Answer
Values-Count of Answer
To Sort the Answer, create a conditional column (Edit Query) :
If Answer is
Agree 1
Strongly Agree 2
Disagree 3
Strongly Disagree 4
Close & Apply
Select the column Answer in your fields panel and go to modeling Sort By Column: Thenameofyourconditionalcolumn
Switch the fields?
This is what my Visualisation pane and my data looks like, but i'm not sure how to do this:
First, you need to transform your data:
Go to Edit Query, Select all the columns and Go to Transform - Unpivot Columns
Change the name of columns like you want.
Close & Apply
Create a Chart
Legend-Answer
Details-Type
Values-Count of Answer
Other alternative Chart
Legend-Type
Details-Answer
Values-Count of Answer
Hi Guys,
Thanks for all your help so far. I think i'm almost there.Not sure if i am doing something wrong or missing a step, but this is the chart that I get:
Hi rcardozo,
In the Pie Chart, the different colour sectors(like the Red, Yellow, Green, Black) display there are four dategoreis in your Answer field. For each sector, there are multiple sub-sectors based on your Type field. If the result is what you want?
Best Regards,
Angelia
You need to transform the data into something like this:
Then You get this:
