2 Replies Latest reply on Jun 27, 2016 8:10 PM by Nicholas Gorman

    Help with formatting

    Nicholas Gorman

      Hey Everyone,

       

      So I am trying to build a view where customer responses from a survey are filtered by quarter to show the count of each responses to the survey. Here is a view of the data when it is not filtered by quarter of response:

       

       

      The problem is after I filter it to one certain quarter, there are 0 customers who responded with certain scores. So the graph is missing some of the columns. It looks like this:

       

       

      How can I make the columns for 1,2, 4 and 6 show up even though 0 customers have responded with that answer?

       

      The data is layout like such:

       

       

      cust-idresponse Quarter
      cust-11Q1
      cust-25Q2
      cust-33Q3
      cust-41Q4
      cust-55Q1
      cust-63Q2
      cust-78Q3
      cust-86Q4
      cust-97Q1
      cust-104Q2
      cust-113Q3
      cust-123Q4
      cust-134Q1
      cust-1410Q2
      cust-153Q3
      cust-161Q4
      cust-172Q1
      cust-1810Q2
      cust-193Q3
      cust-207Q4

       

       

      any help would be great

       

      Thanks,

       

      Nick