Chart series based on records rather than fields?
I'm wanting to build a line chart (FM Pro 11) which has Jan-Dec on the x axis and temperature on the y axis. I want one series per year, so e.g. 2010 is overlaid on 2009.
This would look similar to the line chart example at http://www.kegebein.net/blog/2010/03/filemaker-pro-11/
My data is in records, e.g.:
year month temperature
2009 jan 16
2009 feb 17
2010 jan 18
2010 feb 19
From my experiments it seems I have to transpose the data so it looks like this:
month temp2009 temp2010
jan 16 18
feb 17 19
Is there a way to create series based on a variable (year), or do I indeed need to transpose the data first?