Forum Discussion
Summarized table with most common values
Hey Anonymous ,
assuming there is a question where two answers have the same frequency, what is the expected result?
What is the table layout? Is each Question a separate column?
Regards,
Tom
TomMartens thanks!
Table Layout - each question is a separate column with likert scale responses. There are blanks in the responses. There are two broad question categories - importance and performance as shown below.
Some questions have the following answer options:
Important
Less Important
N/A
Neutral
Not Important
Very Important
Others have these:
N/A
Neutral
Satisfied
Unsatisfied
Very Satisfied
Very Unsatisfied
That's a fair question. We do not have any questions where the reponses were the same for each category but in that case, I'm told the minimum value by alphabetical order works.
Hey Anonymous ,
thanks for the clarification.
Please make sure that the sample data be copied to Power BI easily, currently this is not the case. Consider creating an Excel Sheet, upload the xlsx to OneDrive, Google Drive, or Dropbox and share the link. Make sure that no loigin is required for downloading the spreadsheet.
Regards,
Tom
