Forum Discussion
Grouping/ Pivoting Survey Data
Hi BI Community,
I need your help!
Here is what I am dealing with:
1. Survey Data
2. 64 questions
3. 8 Categories
4. Each question is part of one of the categories.
I want to create a decomposition tree where we can break down each category into the relevant questions for the category and show the average scores for that question in that category.
Difficult to explain but I know there are a lot of smart people on here who can help.
Thank you in advance!
4 Replies
Hi Phil,
I can share it with you privately.
How do I do that?
Hi Natedekock
You can send me a Private Message through this forum.
Go to top right of Forum, click on the envelope -> New Message.
Regards
Phil
Hi Natedekock ,
Can you please share some dummy data with similar data structures and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
