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.