AnsweredAssumed Answered

SQL Statement for graph isnt working as expected

Question asked by Tom_Droz on May 31, 2016
Latest reply on May 31, 2016 by user19752

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

Outcomes