Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Prince,
How do I eliminate the blanks in my count?
Dear Harrison,
By default It don't count Blans,So you not need to eliminate blanks.
Thanks & Regards
Prince Anand
Thanks a lot Prince Anand
Welcome Harrison