Do you know ExecuteSQL at all? I'm finding the more and more I use charts, the faster it is setting up as ExecuteSQL. There are some gotcha's on this, however, as well.
Each of your types in your graph is a different data series, so these need to be set up in the chart as a data series. You can point to a field or a calculation. I guess I'd point my series to TOs of the data, where each table occurrence only sees that type of data. So a relationship from your parent TO to the data TO. (Does that make sense?)
Since you're getting the data from a found set, make sure the source is set to be "Found Set" and then make sure the sorting is done by year / month number (so you have the months in the correct order).
That's a start. I'll see if I can be more clear with some digging into it.
Again, though I use ExecuteSQL in all my charting needs.
Thank you very much for the insight. It didn't occur to me to create TO's but after reading your explanation that makes sense. One way I tried to make this work was to create five y-axis series, each a GetSummary based on one of the five Service Categories.
Unfortunately (for me) I don't know any SQL and that's been by design. I just don't want to learn SQL right now. Almost all my of reasoning to use FMP was because it's simple and is an all-in-one solution that makes working with and analyzing my data simple. However, I've been finding the analysis part to be frustratingly lacking and complicated. Maybe it's my expectations that are out of line but I want the analysis part to be as robust and as simple and seamless as what Excel provides. To the point where I have to do my data analytics in FMP and then export it to Excel for reporting, I feel I may have picked the wrong relational database platform for my needs. If that doesn't exist I'll happily suggest this for a future product enhancement.