I am in need of figuring out the correct way to right a query for a report dataset!
The requirement is a matrix or table that has a parent group of Months, then a child group of weeks of that month, and then student scores.
The data shows scores by a standard date...so you could have a score for 3 weeks in Sept and then no scores in all 4 weeks of Oct.
I need to still show the matrix with the null values for the weeks with no score. So i thought an OUTER JOIN between the data table that holds the scores with the date table that has all months & weeks for years.
The problem is when I add the fields to the matrix and then apply a filter to see only a specific group of scores, then I lose the null value weeks of the month. I need to know how to build this matrix or table so that the Months and Weeks are not affected by filters to the data???
Does this make sense? I will continue to plug along, but if anyone sees my flaw or has an idea, please do not hesitate to let me know. THANKS!
The requirement is a matrix or table that has a parent group of Months, then a child group of weeks of that month, and then student scores.
The data shows scores by a standard date...so you could have a score for 3 weeks in Sept and then no scores in all 4 weeks of Oct.
I need to still show the matrix with the null values for the weeks with no score. So i thought an OUTER JOIN between the data table that holds the scores with the date table that has all months & weeks for years.
The problem is when I add the fields to the matrix and then apply a filter to see only a specific group of scores, then I lose the null value weeks of the month. I need to know how to build this matrix or table so that the Months and Weeks are not affected by filters to the data???
Does this make sense? I will continue to plug along, but if anyone sees my flaw or has an idea, please do not hesitate to let me know. THANKS!