0 Replies Latest reply on Jun 18, 2010 2:45 PM by barefootguru

    Chart series based on records rather than fields?

    barefootguru

      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.