AnsweredAssumed Answered

Execute SQL Charting Issue

Question asked by FredH on Dec 23, 2014
Latest reply on Dec 27, 2014 by 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_

Outcomes