4 Replies Latest reply: Dec 1, 2009 1:53 AM by John Witherspoon RSS

    expression to be displayed in percetage


      following is the data structure of my input which is a questionnaire survey result

      1. week_no (survey week of the year)

      2. response

      i want to plot a graph with the following as dimensions

      1. distinct values of 'response'

      2. week_no

      and in expression i want to display the percentage of responses out of the total responses for that particular week.

      i tried with count() and aggr() function but could not arrive at it. it only gave me percentage of responses for all the weeks and not for every week.

      please help me out in forming the expression for arriving at this..