Selection Issue

[#1]

Hey All,

I have an issue -

I have a pie chart that has the expressions :

=count({<Q2LastYearScore = {1}>} responseid)/ count(Q2LastYearScore)

=count({<Q2LastYearScore = {2}>} responseid)/ count(Q2LastYearScore)

=count({<Q2LastYearScore = {3}>} responseid)/ count(Q2LastYearScore)

(where I,2 and 3 relate to different responses)

There are no dimensions.

I have a year filter which has the years 2011 and 2010.

When year is not selected it gives a set of results - lets say results A

When year 2011 is selected it gives set of results B

How would i script this pie chart to only show the 2011 data? and exclude 2010 and combined 2010 and 2011 data. As Year is not being used int he pie chart im lost on what to do.

IF further description - information requiered please let me know.

Thank you.

[swuehl · Accepted solution]

maybe like

=count({<Q2LastYearScore = {1}, year = {2011}>} responseid)/ count({<year = {2011}>} Q2LastYearScore)

etc.

where year is the field name for your year.