**Edit: Found Resolution. Applying filters to Category Groups when I should have applied to Chart itself. After that fix, data displayed without issue.
I've built a stored procedure that compiles survey data from a wordfly Page. I'm pulling the response data directly from the LV_WF_PAGE_FIELD_RESPONSE table. The procedure is pulling the data as expect and it outputs the following data:
1. Production Season description2. Performance name plus date and time description3. Wordfly page question4. Customer's Answer/Response.5. Combined total of each unique response per performance.6. That answers percentage of the total responses for that question for each performance.7. PageFieldResponse number, or ID number from LT_WF_PAGE_FIELD used to filter question responses into their own distinct tables and charts.
We have 3 distinct survey questions we are reporting on.
1. If you did not attend the performance, why? There are 3 options: Covid, Schedule issue, and Other.2. Overall experience? Options 1-53. Health and Safety? Options 1-5
Our goal for each unique question is to display a table showing each options total response and their percentage of the total response for that question. Then also display a bar chart of each options total percentage. I'm creating a chart for each question, using data field 6 (percentage) as the Values, and data field 4 (answers) as the Category Groups. Then I am applying a filter to the Category Groups using data field 7, the id key each distinct question, so I can filter out the responses for questions not involved in that chart. It works just fine when I create my charts for Questions 1 and 3 but for some reason Question 2 always shows up as No Data Available. The data for question 2 is populating the table just fine but it won't populate a chart. Question 3 is basically the same exact question and it populates just fine and I can't seem to figure out why. I tried changing the Value to the data field 5, the combined total for each unique answer but still the same thing. I can't seem to find any distinct differences between their data but for some reason, the filter for Question 2 breaks the chart. I changed to different default data as I test it in the SSDT and still the same thing.