jmci Posted January 10, 2012 Share Posted January 10, 2012 I've been struggling with something and I don't even know if it's possible to accomplish it in FileMaker. A client has acquired data from the Medicare about outpatient surgical procedures that have taken place over the last several years. The data is available in one table that contains many fields but there are three fields of interest: Year: the year in which the surgical procedure took place Payment Amount: the amount paid for the procedure Facility Type: the type of facility at which the facility took place (there are four possibilities) I've also created a summary field called sPaymentAmount My client wants me to provide a line graph of this data with the Year field along the horizontal (x) axis and the Payment Amount along the vertical (y) axis. That's easy enough. I've done that before. The wrinkle is that he wants to see a separate line in the same line graph showing summary Payment Amount data for each of the four Facility types. Can FileMaker do that? What's the trick? Do I have to have the chart in a particular sub-summary part? Link to comment Share on other sites More sharing options...
bcooney Posted January 10, 2012 Share Posted January 10, 2012 I believe you can overlay two charts, literally. Link to comment Share on other sites More sharing options...
jmci Posted January 10, 2012 Author Share Posted January 10, 2012 OK, let's hold that technique in reserve You seem to be able to add more than one y-axis field. Could that be the solution? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4493 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