Getting related survey detail based on chart selection
Hello all,
I have a table that has detail for a customer satisfaction survey. Each row is an answer to a particular question in the survey. For example purposes lets say the table is called Cust_Sat_Survey, and the schema is survey_session_id, questionid, response, customerid, customer_region. The "survey_session_id" is one instance of all of the responses for survey that was taken. The questionid and response are the invidual answers given.
I have a bar chart that is showing how many times a particular question was answered a particular was (using set analysis, questionid = {'6'}, response >= {'4'} on a scale of 1-5) , with a dimension of region. The chart works great and shows how many responses with a score of 4 or greater for each region.
What the customer would like though is a pivot table showing all of the responses in each survey session for the particular region selected in the chart.
So in other words, if I see that the "North East region" has 10 responses greater that 4 for that question, they want to be able to click on the bar and have a pivot table below the chart update to show all of the responses for each survey_session_id for those 10 customers.
Right now, when the bar for "North East" is selected the selections become "North East" and the questionid "6". so the pivot chart shows only the responses for question 6, for all of the North east customers not hust thoses who had 4 or higher. They need all of the questions for the NorthEast customers who answered question with question id #6 4 or higher.
We have other charts for other question, so the same pivot table needs to be used by all of the charts, but not concurrently.
