1 Reply Latest reply on Jul 8, 2014 1:39 PM by philmodjunk

    Sql query in charts

    myemployees

      Title

      Sql query in charts

      Post


           Hi,

           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?