Chart not Displaying - Query Not Valid?

I am trying to create a line chart, with the following query (it works) using PipTotals as the data series and DateOnly as the label.
SELECT

DATE(CloseTime) AS DateOnly,

CAST(Pips AS DECIMAL(7,1)) AS PipTotals

FROM BluePoints

WHERE (Status ='CLOSED') AND (Demo ='NO')

GROUP BY DateOnly

ORDER BY CloseTime DESC

LIMIT 20
It all seems to work, but no chart is displayed. I noticed that the "LIMIT" is not working as the date slider is looking for more than LIMIT 20. I read the manual, and it is not clear to me what is allowed in the query. Seems as if a query runs it ought to display. I removed the slider control filter and it still does not display.
Can you point me in a the right direction on what query to use? Or is there something science I am not seeing?
Another issue: When using a control filter it gets Javascript errors:
Temp image link: