Forum Discussion
combine columns for pie chart
Hi jgoodwin10,
You can refer to the below steps to get the desired results:
1. You need to unpivot the first table to get all muscles (primary, secondary and trinary) in a column
- Go to query editor mode and select the primary, secondary and trinary muscle column and click unpivot in transform tab
- Post this you will have 3 columns Exercise, Attributes (consist primary, secondary and trinary in rows) and values (Consist muscle in rows)
- Close and apply the changes
2. Now you have to create a DIM table which will help you create the relation between new unpivoted table
- you can use the distinct function for that
New table = DISTINCT(Exercise)
3. Create relation ship between all three tables using Exercise column
- Going forward using Excersing column from Dim table and use Value column (from unpivoted column) in pie chart
Hope this helps :)
-Sumit
Advocate IIHi jgoodwin10,
You can refer to the below steps to get the desired results:
1. You need to unpivot the first table to get all muscles (primary, secondary and trinary) in a column
- Go to query editor mode and select the primary, secondary and trinary muscle column and click unpivot in transform tab
- Post this you will have 3 columns Exercise, Attributes (consist primary, secondary and trinary in rows) and values (Consist muscle in rows)
- Close and apply the changes
2. Now you have to create a DIM table which will help you create the relation between new unpivoted table
- you can use the distinct function for that
New table = DISTINCT(Exercise)
3. Create relation ship between all three tables using Exercise column
- Going forward using Excersing column from Dim table and use Value column (from unpivoted column) in pie chart
Hope this helps :)
-Sumit
KasunpathiranaAdvocate IV
You can create the cross filteration as shown in the first picture and the result would be below when you create the Pie Chart. Hope this is the result you are expecting. I try this for the Primary Muscle Group but you can try for others too.
Hope this helps :smileyvery-happy:
Worked like a charm!
Thank you very much!
