Forum Discussion
Solved
Pie Chart Data
Hi Is there a way that i can present my data so it has the categories as the legend, and totals agree/Strongly agree in the pie graph?
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?