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
SELECT COUNT (Ticket_ID)
WHERE Date_Created >=? AND Date_Created <=? AND Priority =?"
;" - "; ""; NOC Dashboard::c_Week_Sun; NOC Dashboard::c_Week_Sat; "Critical")