Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone advise how to do the following?:
We have a question that asks whether someone was treated with respect. The answer options are yes or no.
Want to show this in a chart by 'service area'. This is normally easy but doesnt like it with this chart. Here is expression whiohc makes sense but says no data to display:
([Q11 Did City West treat you with respect on this occasion?]= 'Yes')/Count(TOTAL [Q11 Did City West treat you with respect on this occasion?])='Yes'/'No'
Chris
I think you need this one:
Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} [Q11 Did City West treat you with respect on this occasion?])
/ Count( [Q11 Did City West treat you with respect on this occasion?])
cheers
Try Like below:
For Yes.
=Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} Yes/No) / Count( TOTAL {<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} Yes/No)
For No....
=Count({<[Q11 Did City West treat you with respect on this occasion?] = {'No'}>} Yes/No) / Count( TOTAL {<[Q11 Did City West treat you with respect on this occasion?] = {'No'}>} Yes/No)
and add 'service area' your Dimension.
OR Share your sample Document...
Hi,
Doesn't like yes/no. I have attached some sample app
I think you need this one:
Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} [Q11 Did City West treat you with respect on this occasion?])
/ Count( [Q11 Did City West treat you with respect on this occasion?])
cheers
Hi,
Something like below,
Count({<[Q11 Did City West treat you with respect on this occasion?] = {'Yes'}>} DISTINCT [Q11 Did City West treat you with respect on this occasion?])/
Count(DISTINCT [Q11 Did City West treat you with respect on this occasion?])
Find the attached,
Hope it helps, Otherwise Please ask..
Kind Regards
Khan...
ahhhhhh you alreay got the answer...
Distinct is not correct in this case because you only have "Yes" "No" as possible values (2 distinct values)
thanks
Yes, you are right. My view was only based on data Chris has provided.