Forum Discussion

rcardozo's avatar
rcardozo
Regular Visitor
9 years ago
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?
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    rcardozo

     

    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

     

     

  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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

     

rcardozo's avatar
rcardozo
Regular Visitor
9 years ago

Thanks so much.

I'm very new to BI. How would i go about doing this? Is there a way to combine all the agrees etc in the pie graph?

 

 

Bokazoit's avatar
Bokazoit
Continued Contributor
9 years ago

Like this?

 

 

You need to do it either in SQL or manually. Perhaps using Pivot/Unpivot in SQL or Pivot in Excel can do the job.