Filtering using expression

[chiso_chiso]

I have a crosstable with a fields called Question and Answer. I want to filter only questions with a specific word and count the number of responses.

Example, I want Overall Availability, Coke Availability, 20l Coke Availability, 40l Coke Availability seperately.

See Attached

[jagan]

Hi,

Try like this using wild card characters in set analysis

=Count({<Question={'*Availability*'}>} Answer)

Regards,

jagan.

[Colin-Albert]

You may need to load the question/answer data as uppercase or lowercase to ensure that you count all values of a word if the case varies.

[chiso_chiso]

Is it possible to also filter for 'Yes' answers only as in to say Overall Availability got 5 Yes answers?

[jagan]

Hi,

Try like this

=Count({<Question={'*Availability*'}, Answer={'Yes'}>} Answer)

Regards,

Jagan.

[chiso_chiso]

For some reason when i change the filter word i.e. from availability to say visibility, the result is not changing which is not a true reflection. any ideas why it may be so?

[ashfaq_haseeb]

Check this

Regards

ASHFAQ

[chiso_chiso]

Thanks guys. Further, help if I want to get average of each answer

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[chiso_chiso]

I am successful, thanks to you colleagues.