AnsweredAssumed Answered

Strange Results Using ExecuteSQL for Chart (FMP 13 Pro) Y-Axis Data

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

Title

Strange Results Using ExecuteSQL for Chart (FMP 13 Pro) Y-Axis Data

Post

     I have the ExecuteSQL below that gives me a list in the "Result:" window of the data viewer. However, when I try to include these values (a single list of numbers like 436, 356, etc.), I get total garbage on the chart. I get values on either side of the chart going up and down the chart and the actual "Y values" all appear to have the same number.

     The type of chart is Column

     The X-axis data is blank as there is too much data for the "date" labels.

     The Y-Axis Title is: "Error Count"

     The Y-Axis data is the ExeucteSQL Query below. (I've tried using paragraph markers only, or just "", but get the same thing.)

     X-Axis and Y-Axis Options are default.

     ExecuteSQL ( "Select ROUND(NUM_ERRORS,0) from TABLE1
     WHERE NUM_ERRORS > 0 order by theDate asc, num_errors";
     ¶;
     ""
     )

     Sample section of part of the output is below.

     What gives here?

     Thanks in advance.

StrangeChartDisplay.png

Outcomes