barand

Charting with ExecuteSQL

Discussion created by barand on Sep 22, 2017
Latest reply on Sep 24, 2017 by Orlando

Hello Filemaker users,

 

I am using two executeSQLs to create a Column chart but it does not show the graph as desired.

 

Result:

 

Used data:

x-axis:

ExecuteSQL ( "

SELECT StappenGereedDatum

FROM Bestek

GROUP BY StappenGereedDatum

ORDER BY StappenGereedDatum ASC"

; "" ; ¶ )

 

y-axis:

ExecuteSQL ( "SELECT COUNT(*)

FROM Bestek

WHERE StappenGereedDatum IS NOT NULL

GROUP BY StappenGereedDatum

ORDER BY StappenGereedDatum ASC"; "" ; ¶)

 

Preferred result: That the bars move one spot to the right.

 

Does anybody know how to get the preferred result?

 

Kind regards,


Baran

Outcomes