Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi Anand,
You could try something like this:
=count(Response)/count(TOTAL <WeekNo> Response)
Thanks
Hi,
I have attached QV application with the expression in it.
Hope this is what you asked for.
Milda
Hi,
Thanks.Its working fine.
What if i want to enhance by replacing the Week Dimension with the Hierachical group ( Year - Quarter - Week)
Just put the group name where the field name is now:
=count(Response)/count(TOTAL <YourGroup> Response)