AnsweredAssumed Answered

Execute SQL Charting Issue

Question asked by MorkAfur on May 22, 2014
Latest reply on May 23, 2014 by MorkAfur

Title

Execute SQL Charting Issue

Post


     Starting a new topic since the old one is probably confusing at this point.

     I'm gathering no one wants to download a FMP12 file and try to run it so I've made a comprehensive screen shot of what's happening.

     Basically there are 10 "x" values (Field Value1) and 10 "y" values (field Value2).

     Using an ExecuteSQL in the data viewer shows all the y values as expected, YET, when using the same ExecuteSQL in the chart, I see all the same value. I've tried having the "p" in the ExecuteSQL and the "". Tried using the option, as PMJ suggested, for "delmited data" etc.

     Nothing works.

     This example is about as simple as I can think of that duplicates the actual issue I'm having.

     No need to "sort" or "group" since I just have 10 x values and 10 y values I want to chart.

     Hopefully someone can see what's wrong -- see screenshot below.

     The example shown in the screenshot below uses an "Order by" clause, but it doesn't make any difference. Also, there were two "10" Value1s. I removed the second one from the data, but didn't completely update the graphic below. In any case, it didn't make any difference to remove the second 10 from the Value1 set of values.

     Thanks in advance.

ExecuteSQL-ChartIssue.png

Outcomes