expression to be displayed in percetage

[#1]

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..

[#2]

Hi Anand,

You could try something like this:

=count(Response)/count(TOTAL <WeekNo> Response)

Thanks

[#3]

Hi,

I have attached QV application with the expression in it.

Hope this is what you asked for.

Milda

[#4]

Hi,

Thanks.Its working fine.

What if i want to enhance by replacing the Week Dimension with the Hierachical group ( Year - Quarter - Week)

[johnw]

Just put the group name where the field name is now:

=count(Response)/count(TOTAL <YourGroup> Response)