10 Replies Latest reply on May 31, 2016 7:44 AM by user19752

    SQL Statement for graph isnt working as expected

    Tom_Droz

      I have 57 records in a table "VL_ForSale"

      with a field name of "SubStatus"

      Data in that field first 52 records = "For Sale"

      Next  3 Records = "Scrap"

      Last 2 = "Wholesale"

       

       

      I am trying to chart with a Execute SQL statement as shown here:

       

      GetColumn (

       

      ExecuteSQL (

       

      "SELECT \"SubStatus\", COUNT (*)

      FROM \"VL_ForSale\"

      WHERE \"SubStatus\" <'a'

      GROUP BY \"SubStatus\"

      ORDER BY \"SubStatus\" ASC" ;

       

       

      "|" ; ""
      ) ;

       

      "|" ;

       

      2 )

       

      the Graph is not showing data as expected:Graph.PNG