Forum Discussion
Helper IVSurvey Data - Percentages based on categories(?), Columns
HEY,
first you need to tranform that data on power query:
select the base columns (not the one with the questions) and use the unpivot others column function here, so any new question added to the data get in the tranformation correctly.
them you can add this to a simple matrix first option:
and them on the value field format you put it on row total value % and will give the value as you looking for.
Resident RockstarHEY,
first you need to tranform that data on power query:
select the base columns (not the one with the questions) and use the unpivot others column function here, so any new question added to the data get in the tranformation correctly.
them you can add this to a simple matrix first option:
and them on the value field format you put it on row total value % and will give the value as you looking for.
Helper IV
Thanks for the reply. I've tried this solution myself however it's not providing the outcome I need.
Perhaps I wasn't clear enough, and i've also had the thought of visualising responses by question (rather than all questions together). Would it be possible to have something like this:
Q3a =
Col 1 = Base
Col 2 = Always
Col 3 = Often
Col 4 = Sometimes
Col 5 = Rarely
Col 6 = Never
And then based on the number of responses received per base, calculate the percentage of responses against each type (always, sometimes etc.)?
It's critical that my percentages are not based on the entire dataset as there are varying numbers of responses per base.
Hope this clarifies my requirements!
Thanks