Frank, you need to remove ORDER BY (there is a separate field for this on SQL Query tab).
You might need to remove LIMIT clause as well.
F
frocco author8/9/2007
Sergey, I removed the order by clause and it still complains with the limit. If I do not use the limit 5, it returns too much data for the chart to display properly. Thanks Frank
F
frocco author8/9/2007
Sergey, I got around this by tacking the Limit 5 on before the SQL is executed.