Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm sure someone will be able to help me again with the syntax on this one......
I have a pie chart that shows the percentage of times something happens (Field = [Questions Complete] = 'Yes'), it counts the number of times people answer a question divided by the total number of people.
Here is the current expression: Count({<[Questions Complete]={"Yes"}>}[Questions Complete])/Count(TOTAL [Questions Complete])
This works perfectly however what i want to do is replicate this chart but only show a specific selection of those people.
(Specific people being from a certain 'Place' but not from a certain 'Place to' providing they answered the question as "Yes")
I attempted to alter the expression to a similar one i already have that can count the specific people but i'm clearly doing something wrong.
Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete]='Yes')/Count({<Place={'09',[Place to]-={'07','FAS'}>}[Questions Complete])
Can anyone help?
Try this.
Count({<Place={'09'},[Place to]-={'07','FAS'},[Questions Complete]={'Yes'}>}[Questions Complete])
/
Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete])
It miss a bracket:
Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete]='Yes')/Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete])
Thanks for spotting that, unfortunately that was just my bad typing putting it on here.
When i use that expression it shows it as 100% which isn't correct.
Try this.
Count({<Place={'09'},[Place to]-={'07','FAS'},[Questions Complete]={'Yes'}>}[Questions Complete])
/
Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete])
Hi
Try
Count({<Place={'09'},[Place to]-={'07','FAS'}>}[Questions Complete]='Yes')/Count({<Place={'09'},[Place to]-={'07','FAS'}>} TOTAL [Questions Complete])
Adrian
Fantastic, this worked a treat.
Thank you very much.