Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Data
My data set is made up of 6 Grades, 20 Teacher, 275 Student and not every teacher teaches every Grade
I need a table that has Teacher Name, No. of Grades, No. of Student but I end up getting 6 Grades and 275 students for every teacher.
My expression is... Aggr(Count(distinct [Grade]), [Teacher])
What am I doing wrong?
Neil
Do you have Teacher and Grade in separate tables? Is the data model well connected if the data is coming from different tables? Also, if you Teacher Name as a dimension, then your expression should be enough (assuming that the data model is well linked)
Count(DISTINCT Grade)
Please post your sample data and approach.
Because this is unusual.
Do you have Teacher and Grade in separate tables? Is the data model well connected if the data is coming from different tables? Also, if you Teacher Name as a dimension, then your expression should be enough (assuming that the data model is well linked)
Count(DISTINCT Grade)
thank you Sunny.
I converted my single table into a multi-table star-schema and now I'm getting the right results.
Neil