AnsweredAssumed Answered

Sql query in charts

Question asked by myemployees on Jul 8, 2014
Latest reply on Jul 8, 2014 by philmodjunk


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?