Newbies FredSa Posted March 22, 2012 Newbies Share Posted March 22, 2012 Hi, Having trouble grasping the charting engine. I have a table with the follow rows: SchoolType | Percent | Year | Total Students MS | 99 | 2010 | 12 MS | 22 | 2010 | 10 HS | 80 | 2011 | 25 HS | 70 | 2011 | 20 I would like a bar chart so that there are two series. The first series would be the MS with data from 2010 & 2011 percent average in two bars and then the HS with data from 2010 & 2011 percent average in two bars I can only get as far as the attached chart. I am stuck figuring out how to chart only the 2010 data as a total and then chart only the 2011data as a total. Help! ZIP of FileMaker file attached. Thanks! BarProblem.fp7.zip Link to comment Share on other sites More sharing options...
comment Posted March 22, 2012 Share Posted March 22, 2012 I have a table with the follow rows: SchoolType | Percent | Year | Total Students MS | 99 | 2010 | 12 MS | 22 | 2010 | 10 HS | 80 | 2011 | 25 HS | 70 | 2011 | 20 Why doesn't your file fit your example? Link to comment Share on other sites More sharing options...
Newbies FredSa Posted March 23, 2012 Author Newbies Share Posted March 23, 2012 I apologize, my mistake. Proper version attached here. barVersion2.fp7.zip Link to comment Share on other sites More sharing options...
comment Posted March 23, 2012 Share Posted March 23, 2012 How about this way? barVersion3.zip Link to comment Share on other sites More sharing options...
Newbies FredSa Posted March 23, 2012 Author Newbies Share Posted March 23, 2012 This is fantastic! Many thanks. Am I correct that what you did was look at the data in a relationship style so that you can match a single school record to many records of years? Link to comment Share on other sites More sharing options...
comment Posted March 23, 2012 Share Posted March 23, 2012 Yes, something like that. The first problem is that the years you want to compare must be explicitly indicated somewhere. The second problem is that there is no way to narrow down a summary expression by a specific year. Link to comment Share on other sites More sharing options...
Newbies FredSa Posted March 25, 2012 Author Newbies Share Posted March 25, 2012 I saw the same problems and couldn't get around them much. Summary reports are my weakness since I haven't had much practice with reports. Do you or anyone else know of resources to help think out these processes for charting? Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4417 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now