Forum Discussion
Anonymous
4 years agoNot applicable
Analyzing feedback data with 40 Yes/No columns
Hi all,
I have a dataset with 40 1/0 (Yes / No) columns.
Example like:
Since there are so many categories, I have a hard time figuring out how to display it.
My idea is maybe to "Rank" the sum of each category.
So based on the filtering, you can always see which category has the biggest frequency etc.
How would I do this, when it is different columns?
Thanks!
Anonymous , On way, is unpivot those 40 columns
Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11
2 Replies
- amitchandakSuper User
Anonymous , On way, is unpivot those 40 columns
Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11
- AnonymousNot applicable