Execute SQL Charting Issue
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!