AngeloWolfe
New member
- Local time
- Today, 06:13
- Joined
- Jun 22, 2011
- Messages
- 6
Greetings AW! I can always counton you guys to help me out when I'm having really wierd issues.
So, here's the scenario. I have a database (Database_1) that multiple users are using. The database works as a survey tool. The user has the option to view all of the surveys each participant has taken (The data is housed in tbl_1 in this example), or they can pull a form up and choose their name from a form, and it brings up a filtered query with just their surveys. The user then chooses from a DDL whether they approve, reject, or other. What I would like to do is have a bar / pie graph that shows the percentage of surveys that were approved, the percentage rejected, and the percentage of others chosen.
From what I've been able to gather, I should be able to use the "Insert Chart" control specify my category, series, and data but I'm not having any luck at all! I will have the "Survey Type" at the category, "Survey Choice" as the series, and -at the moment- a CountOfSurveyChoice for the data. Once I navigate to the "finish" page, a bar / pie graph is displayed that shows me (Q1, Q2, Q3, Q4) as the categories, and has a bunch of random numbers generated that does not reflect any of my data!
Any suggestions on fixing this problem will be greatly appreciated! If you need anymore information, just let me know.
So, here's the scenario. I have a database (Database_1) that multiple users are using. The database works as a survey tool. The user has the option to view all of the surveys each participant has taken (The data is housed in tbl_1 in this example), or they can pull a form up and choose their name from a form, and it brings up a filtered query with just their surveys. The user then chooses from a DDL whether they approve, reject, or other. What I would like to do is have a bar / pie graph that shows the percentage of surveys that were approved, the percentage rejected, and the percentage of others chosen.
From what I've been able to gather, I should be able to use the "Insert Chart" control specify my category, series, and data but I'm not having any luck at all! I will have the "Survey Type" at the category, "Survey Choice" as the series, and -at the moment- a CountOfSurveyChoice for the data. Once I navigate to the "finish" page, a bar / pie graph is displayed that shows me (Q1, Q2, Q3, Q4) as the categories, and has a bunch of random numbers generated that does not reflect any of my data!
Any suggestions on fixing this problem will be greatly appreciated! If you need anymore information, just let me know.