|
User Details |
message
|
|
Kennan Wood
post date:
2010-10-01 15:08:38
|
|
How do I make a pie chart with multiple recordsets? I have 5 different recordsets that have different totals that I would like to place in a chart. Please help.
|
|
|
Andrei Rinciog [Extend Studio]
post date:
2010-10-04 06:55:30
|
Hello,
I guess your recordsets are connected since you want to use them in a single chart. Isn't there any way you could get the data you need with a single recordset instead of 5?
Regards,
Andrei RInciog
|
|
|
Kennan Wood
post date:
2010-10-04 11:33:44
|
Andrei,
No, the database has a field that takes various responses and I need to be able to sort out each response separately. I take it that the extension does not allow for multiple recordsets.
Kennan
|
|
|
Andrei Rinciog [Extend Studio]
post date:
2010-10-07 04:34:35
|
Hello,
You can use multiple recordsets but not on single series charts. And the pie chart is a single series chart.
I still can't understand how your database is set up. The pie chart is like a comparison tool. It creates the chart based on the values multiple records of the same type.
You can't use an aggregate function like "group by" ?
Please tell me a little more of the structure of your database so I can be able to help you in more detail.
Regards,
Andrei Rinciog
|
|
|
Kennan Wood
post date:
2010-10-12 12:25:57
|
Andrei,
The database is set up with a field called q1 which accepts answers from a survey of values from 1 to 5. I need to count all the 1s, 2s, 3s, 4s and 5s in that field separately. So this field has 6 responses of 1, 5 responses of 2, 0 responses for 3 and 4, and 2 responses for 5. The challenge is counting the responses in one recordset.
Kennan
|
|
|
Kennan Wood
post date:
2010-10-12 12:43:40
|
Andrei,
Maybe this will help: http://www.wiroundtable.org/summit/gov_results.asp
The Agree Strongly (1), Agree Somewhat (2), Disagree Somewhat(3), Disagree Strongly (4) and NA/NS (5) are the response options that need to be calculated and used in a chart. Each question is one field.
Kennan
|
|
|
Andrei Rinciog [Extend Studio]
post date:
2010-10-13 04:28:28
|
Hello Kennan,
I made a test on a table with two columns: "id" and "answer". My "answer" column has values from 1 to 5 just like your q1 column.
To count the number of each response I used this query:
SELECT count(id), answer
FROM table
GROUP BY answer
Try a similar query on your table and tell me if you get the results you want.
Documentation for the GROUP BY function can be found here: http://www.w3schools.com/sql/sql_groupby.asp
Regards,
Andrei
|
|
