4 Replies Latest reply on Jun 20, 2017 1:14 PM by xxx202xxx

    Issues with my Bar Graph using ExecuteSQL

    xxx202xxx

      I am having issues with my graph trying to get data to show up on the correct month.  I'm not sure what I am doing wrong.  The data is being displayed under January only.

       

      X-Axis =

      "Jan" &  ¶  &

      "Feb" &  ¶  &

      "Mar" &  ¶  &

      "Apr" &  ¶  &

      "May" &  ¶  &

      "Jun" &  ¶  &

      "Jul" &  ¶  &

      "Aug" &  ¶  &

      "Sep" &  ¶  &

      "Oct" &  ¶  &

      "Nov" &  ¶  &

      "Dec"

       

      Y-Axis =

      ExecuteSQL ("

      SELECT COUNT (Ticket_ID)
      FROM Service_Management
      WHERE Status IN (?)"
      ;" - "; ""; "WIP")

       

      ExecuteSQL ("

      SELECT COUNT (Ticket_ID)
      FROM Service_Management
      WHERE Status IN (?)"
      ;" - "; ""; "Pending")

       

      ExecuteSQL ("

      SELECT COUNT (Ticket_ID)
      FROM Service_Management
      WHERE Status IN (?)"
      ;" - "; ""; "Closed")