Help to create repport that counts unasigned cases
I am a neewbie and need some SQL-help for a report.
I am trying to make a report that displays number of cases thats opened/made the last "month" (the "month" last from the 11th to the 10th), how many of the cases that's closed/finished and number of cases that are unasigned to either a category or person (the default category is "Other :: Møterom"). I guess its easer to display if it is unasigned to a person.
Instead of making indivudial reports for different months a report for the whole year with separation for the different months is ok.