AnsweredAssumed Answered

Issues with my Bar Graph using ExecuteSQL

Question asked by xxx202xxx on Jun 20, 2017
Latest reply on Jun 20, 2017 by 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")

Outcomes