Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Frequency Table.

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. Somet...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    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

TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

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

     

    Thanks again. :)