Counting instances of word across rows to create numerical data

[Anonymous]

I am looking to count the number of times specific words appear in a row.

I want to be able to show percentages and also counts of the instances.

Currently, I have these in a donut chart but adding each column to the values as distinct counts. Its not great and cant show each section as a full percentage etc 

In the real world these are relative to construction health and safety and if specific sections are compliant or not

Any help here would be great.

Thanks

[v-yiruan-msft · Accepted solution]

Hi @Anonymous,

Whether Dotnut chart in below screen shot is your expected result? If yes, first please unpivot all of columns except the column "Date", then drag the fields (Legend: Value  Details: Date  Values: Count of Attribute) on Dotnut chart...Unpivot selected columns

Expected result

Best Regards

Rena

[tex628]

I would start by doing an unpivot on your data. Go into the query editor, highlight all columns apart from your date column and then press unpivot columns. You will find the button under the transform tab. 

When the data is formatted you should simply be able to use the normal integrated count of to display both count and %. 

Let me know if you have any questions. 

Br,
Johannes