AnsweredAssumed Answered

Charting Issues using ExecuteSQL

Question asked by xxx202xxx on Jun 23, 2017
Latest reply on Jun 23, 2017 by xxx202xxx

This issue has been plaguing me for a little while and I don't know (after several attempts) what to do. I am getting the correct data returned in data viewer but for some reason I can't seem to display the data correctly in a chart, Line nor Bar chart where I want to chart each priority separately.  What I do get is the data showing up only for Day 1.  I want to see the names Sun thru Sat with values for when the ticket was created showing for their specific day

 

 

c_Week_Sun  =  Let ( [D = Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) ) - 1 ) ; D1 = D - DayOfWeek ( D ) + 1] ; D1 + c_Week * 7)

c_Week_Sat   =  Let ( [D = Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) ) - 1 ) ; D1 = D - DayOfWeek ( D ) + 1] ; D1 + c_Week * 7) + 6

 

X-Axis = NOC Dashboard::Date_Created  ≥   NOC Dashboard::c_Week_Sun AND NOC Dashboard::Date_Created ≤ NOC Dashboard::c_Week_Sat

 

Y-Axis=

ExecuteSQL ("

SELECT COUNT (Ticket_ID)
FROM Service_Management
WHERE Date_Created >=? AND Date_Created <=? AND Priority =?"

;" - "; ""; NOC Dashboard::c_Week_Sun; NOC Dashboard::c_Week_Sat; "Critical")

 

Outcomes