Frequency Table.

[Anonymous]

Hello!

I am working with data like this where I have a user and they are "rating" 5 items:

I would like to find the frequency of how many times each rating comes up under each item. Something that looks like this, where the blank cells would the the count or frequency how many times that rating comes up in the entire table:

Thanks so much in advance!

[TeigeGao · Accepted solution]

Hi @Anonymous ,

Firstly, we need to unpovit this table like below:

Then we can create a table like below, this table is used for displaying the column name, then we need to create relationship between the column 2 and Value of above unpovited table.

After that, we can drag the Column 1 as column name, Attribute as the row name and value as the value, we need to set the value as count:

Best Regards,

Teige

[Anonymous]

@TeigeGao THANK YOU SO MUCH. Your reply was so well thought out and informative. I tried it and it worked!

Thanks again. 🙂