AnsweredAssumed Answered

Chart Question - No chart data displaying

Question asked by fmpdude on Dec 9, 2016
Latest reply on Dec 9, 2016 by philmodjunk

I created a chart that has percent values from 0 to 100. The ExecuteSQL for the y-axis produces values like this (all between zero and 100):












The SQL for the y-axis looks like this: ExecuteSQL("select ROUND(pct,2) from checks where pct is not null order by chk_date asc" ; "";  "")




My chart setup looks like this:

And, in the Data Source Section, I have:


I didn't fill in anything for the x-axis since I just want the y-axis data, which works fine if I just use the field and not an SQL for the y-axis data.


Now, although the above SQL works fine in DV, the chart is always empty. I also tried using a paragraph mark for the second parameter. No difference.


I fiddled around with all the Data Source options, but that couldn't find one where the data displayed.


Surprisingly, if I switch axes, I do see the data values crammed on to the x-axis.



If I uncheck the x-axis and y-axis constraints, then I get a graph like this below. The y-axis is way off given the decimal data between 0 and 100.


Would appreciate any suggestions.