Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
PLease find the attahcment of the QVW file and Excel file.
I have a bar chart which will show the values of created and closed tickets each month respectively ...
count of created is showing properly but Count of Closed is adding up everything...
i need to chow the count of closed for the selected month only which should be like , if the entry is missing in closed date the it should consider the count of resolved that for that perticular month
only.
For example:
slelect Level = Low For Feb-2017 open is giving the correct value which is 59 ... and close value is showing wrong as 40 , which should be 16 that is sum of closed and resolved tickets only for Feb-2017 (selected month)
thanks in advance
John,
40 is correct
28 Count(Closed) + 12 IsNull(Closed) with Resolved
Regards,
Antonio