1 Reply Latest reply on Jul 16, 2017 6:17 AM by philmodjunk

    Temporarily add portal rows to a table for displaying in a chart

    drvidyut

      I want to display a childs weights in a chart which will already be populated with standard values (from a table) as given by cdc/who. So basically I have to display two data series

      1. X-axis will have age in months

      2. Y axis will have standard weight according to age in months till upto three years (It comes out to be a smooth curve). See figure

      3. 2nd series on Y -axis will have the childs weight recorded at particular ages.

       

      Both these data are on separate tables in my database

       

      Thanks in advance

        • 1. Re: Temporarily add portal rows to a table for displaying in a chart
          philmodjunk

          If you use the delimited data source option, you can use ExecuteSQL to pull data from one table for one y-series and a different ExecuteSQL call to pull data from a different table for the other. A list function with quoted values can give you ages in months for your x-axis.

           

          Please note that FileMaker Charts require a corresponding y value for every x. If you have gaps in your y-series data, you'll have to add interpolated values to keep the curve smooth.