AnsweredAssumed Answered

Chart series based on records rather than fields?

Question asked by barefootguru on Jun 18, 2010

Title

Chart series based on records rather than fields?

Post

Hi guys,

 

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?

 

Thanks.

Outcomes