Cross Table Count and Average

[chiso_chiso]

Kindly assist.

Using the attached, I have loaded my Data as a Cross table but I can not proceed from there. I have loaded the attributes as Questions and the Data as Answers.

I want to determine the count of Yes' and Nos for every question and establish the average i.e. TotalCountYes/TotalCountShopName

[#2 · Accepted solution]

Dear Harrison,

Please try the attached QVW for Solution:-

In Straight Table take Questions as Dimension and use three expressions:-

Yes:- count({$<Answers={'Yes'}>}Answers)

No:-  count({$<Answers={'No'}>}Answers)
Average:- count({$<Answers={'Yes'}>}Answers)/count([Shop Name])

Thanks & Regards

Prince Anand

[chiso_chiso]

Thanks Prince,

How do I eliminate the blanks in my count?

[#4]

Dear Harrison,

By default It don't count Blans,So you not need to eliminate blanks.

Thanks & Regards

Prince Anand

[chiso_chiso]

Thanks a lot Prince Anand

[#6]

Welcome Harrison