1 2 Previous Next 22 Replies Latest reply on Dec 27, 2014 10:03 AM by FredH

    Execute SQL Charting Issue

    FredH

      Title

      Execute SQL Charting Issue

      Post

      Hi Experts,

      I have issues with FileMaker Graphs using delimited data and ExecuteSQL function. 

      I am trying to make a line chart where I have my years on my X axis. 
      I have defined following ExecuteSQL functions : 
      X : ExecuteSQL("SELECT DISTINCT E.\"Année\" FROM Exploitation AS E ORDER BY E.\"Année\" ";"";"")
      Y : ExecuteSQL("SELECT sum(E.\"NOP Frais incl.\") FROM Exploitation AS E GROUP BY E.\"Année\" ";"";"")

      Result : My X axis shows the correct years but my Y axis stays empty although the same query shows the correct result in my data viewer.

      Any idea what I am doing wrong here?

      Thanks in advance for your input!
      Kind regards,

      _Fred_

        1 2 Previous Next