AnsweredAssumed Answered

Google Chart for FileMaker Runtime

Question asked by amdjc on Oct 16, 2017
Latest reply on Nov 15, 2017 by amdjc

Hello! I recently came across a Youtube video (https://www.youtube.com/watch?v=S7RcdG5v-sQ) on incorporating Google charts on FileMaker. It’s the only tutorial I saw regarding this topic. Albeit an excellent tutorial, I need help in incorporating column charts, which seems a bit more complex.

 

I managed to make a Filemaker graph using ExecuteSQL but I need the graph for runtime, hence the Google chart. Can anyone show/teach/guide me how I can incorporate same details of this graph (photo––Filemaker chart) using Google charts? Thank you very much!

 

X-Axis

    ExecuteSQL ( "

     SELECT DISTINCT \"MonthName\"

     FROM \"Treatment\"

     ORDER BY \"Month\"";"";"")

 

Y-Axis

     1.    ExecuteSQL("

             SELECT SUM (Amount)

             FROM Treatment

             WHERE \"Year\" = \"Current\"-1

             GROUP BY \"Month\"";"";"";"\"Current-1\"-1" )

     2.     ExecuteSQL("

             SELECT SUM (Amount)

             FROM Treatment

             WHERE \"Year\" = \"Current\"

             GROUP BY \"Month\"";"";"";"\"Current\"" )

Outcomes