I'm trying to make a few bar charts that show responses to an engagement survey as a percentage of the response rate & I'm having issues making the set analysis work
I have filters for Site/Department/Length of Service in the Sheet - and when someone selects the filter, say for Site = London, I want the response to show as a percentage of the site selected. If no response is selected, it should be over a total of every response given.
Each Response (row) is given a unique identifier, but the questions (I'm struggling with) are multi-choice.
The responses to the questions are
'Vey poor', 'Poor', 'Fair', 'Good', 'Excellent'
If I have no site selected, I get the total "Poors" / Total Responses, which is correct however if I Select a Site filter, I get the Site's "Poors" / Total Responses, not the TotalSites Responses
Engagement:
LOAD
RowNo() as Engagement_Id,
Site,
"Which department do you work in?" as Department,
"How long have you worked for the company?" as "Length of Service",
"What do you like most about your role and why?",
"What do you least like about your role?",
"I know what is expected of me in my job",
"Parking facilities",
Pick(WildMatch( "Parking facilities", 'Vey poor', 'Poor', 'Fair', 'Good', 'Excellent'), '1', '2', '3', '4', '5') as "Parking facilities Value"
