5 Replies Latest reply on Nov 12, 2014 2:07 AM by Siraj Samsudeen

    How to pad a rating column so that all values are displayed

    Siraj Samsudeen

      As you can see from the screenshot below, I am displaying all possible ratings (0 to 10) on Rows, the attribute on Columns, and the percentage of responses for each attribute against each rating in the Text area in the table. I want to filter this table by Attribute A, but when I do that, rating 0 & 1 disappear as there are no records with these 2 ratings for Attribute A. I want to pad this rating column so that displays all the 11 values from 0 to 10 are displayed.

       

      Padding rating column.JPG

       

      I have searched in the forum and came across this thread Missing values in dimensions

      The problem is similar and I have looked into the solution posted by Jonathan Drummey, however the solution is a bit complex - in my case, do I really need to use SQL scaffolding to achieve what I want or is there a simpler way to do this using data blending or any other techniques?

       

      I am attaching the workbook with the data.