A pie graph can only have one data series, and that series is sorted into its groups. So obviously you wouldn't get all the question's responses on one graph. If you want to see a pie chart for all 5 questions, you'd need to create 5 pie charts, each pointing to a different field.
So does your Feedback table have multiple records for each client? Does client A have 10 feedback responses, for example? If so, you can use the pie chart to display a summary of each response for each question. Another question: Your tables are related, right? I assume so. In my sample one, the primary key for the client is the foreign key in the Feedback table. Client::ID = Feedback::ID_Client
In your feedback table, you need to include a summary field for each Question field. It needs to be a COUNT summary type. I named mine Count_Q1
TO set up your table, do this:
- In your feedback table, you need to include a summary field for each Question field. It needs to be a COUNT summary type. I named mine Count_Q1
THen do this to set up the chart:
- On the client layout, draw a pie chart.
- In the Category Labels dialog box, click on the ... and choose "specify field".
- Navigate to the Feedback table and choose the field Q1 (this will give you the unique values of the field: "Good" , "Satisfactory", "Poor".)
- In the Slice Data box, click the ... and choose a field. This time choose the Feedback::Count_Q1 field.
- Choose any options you want.
- Click on the "Data Source" tab (lower part of the right side of the chart)
- Here, choose "Related Records".
- Choose the related table "Feedback"
- Sort the records by the Feedback::Q1 field.
- Finally choose "Summarized groups of records" in the Chart Display when sorted field. (this will prevent all the records from showing up and will trigger the Summary field you created.
Hey Thanks a lot for reply and explain everthing so deeply. I try this And its working and I also got the idea about the charts and summary field also.
I m getting wrong output ..e.g Here for ABC client there are 2 records for this client both are GOOD But its count 3.
Could ypu please give ur example 's download links or post it here ?
q1.png 41.6 K
Hmmm. If both the responses are "Good", they should show up together and the pie chart should have a solid circle. Could one of the records have a return character in the field after the "Good"? Filemaker would see that value as different than "good".
I'd check your summary field. Make sure it is set to COUNT of the Q1 data. Double-check to make sure your pie chart is sorting by the Q1 field. Make sure that your Q1 field is set to "Text" type.
Without looking at your file and the fields and the pie-chart set up, i cannot diagnose exactly.
Hey I solve this.Thanks for ur help