6 Replies Latest reply: Feb 4, 2014 6:40 AM by Nilesh Gangurde RSS

    % by month

    BELEN VERA GARCIA

      Good morning,

       

      Please, could someone help me with this scripting:

       

      I i put this expresions:

       

      1)  Number

      ( distinct CSQUEST_ID)

       

      2)%:

      ({<[Question Desc]=>} distinct CSQUEST_ID)/count({<[Question Desc]=>}total distinct CSQUEST_ID)

       

       

      I get this table:

                                                                         

      YEAR_MONTH2013/062013/062013/072013/07
      Age RangeNumber%Number%
      18-24871,7%1422,8%
      25-343937,7%62712,2%
      35-443777,3%77915,2%
      45-544057,9%87817,1%
      55-644298,4%4789,3%
      65-742695,2%2023,9%
      75 or more370,7%310,6%

       

       

      The issue is that what i want to get is this table: ( A percentage of the month)

         

      YEAR_MONTH2013/062013/062013/072013/07
      Age RangeNumber%Number%
      18-24874,4%1424,5%
      25-3439319,7%62720,0%
      35-4437718,9%77924,8%
      45-5440520,3%87828,0%
      55-6442921,5%47815,2%
      65-7426913,5%2026,4%
      75 or more371,9%31

      1,0%

       

       

      Is this possible?? Thanks a lot!

      Belén