Sql query in charts
I've been trying to figure out how I can use a sql query in charts.
For example, I have a table layout with large header and would like to display the overall results on the chart.
Table records has the following fields.
sessionid, user, and answer
There are total of 30 records with grouped by 3 users. (each has 10 records).
I have created a sql statement " SELECT distinct sessionid FROM answers" and placed in X axis.
However, instead of showing only 3 unique values, I do see tons of data in the chart's x-axis.
Anyone have any idea?
ExecuteSQL ( " SELECT distinct sessionid FROM answers" ; "" ; ¶ )
Should work, provided that you use the "delimited data" data source option.