Strange Results Using ExecuteSQL for Chart (FMP 13 Pro) Y-Axis Data
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.