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):

 

22

27.92

36.62

30.5

.

.

.

 

----------

 

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.

 

Thanks

Outcomes