2 Replies Latest reply: Jun 27, 2014 11:58 PM by ar eiuiew RSS

    Designing a two dimensional table

    ar eiuiew

      Hey Guys!

      with your help i have designed most of the dashboard i needed. I owe you so much and I don't know how to thank you for your support.

      the only thing that is left is a two dimensional table which has 12 columns (number of questions in the data model) and 32 rows (number of cities).

      there are 2 things that i don't know how to create:

      1- the table structure itself ( since the question has 5 possible answers {highly agree,agree,highly disagree, no opinion} when i chose the questions for dimension it shows the possible answers : {highly agree,agree,highly disagree, no opinion}  , but l want to have the percentage of people who are {highly agree,agree,highly disagree, no opinion} in all cities .

       

       

      2- the way i should script to count the all the people who are {highly agree,agree,highly disagree, no opinion} in one city so i can calculate the percentage.

      as you can see in the picture below, i have to have 5 row for each city to see the percentage of each possible answer. i guess it's a little tricky..isn't it?

      what would you do to show the results?

      thank you again

       

      table.png