Forum Discussion
Count related items
Hello, I have a quite basic scenario (in Direct query) but I cannot find a basic solution for it. It only involves 2 tables and a relation between the two. Lets say I have a Person table and ...
I don't exactly get what you need. Your data table seems to suggest 1 Case only has 1 subject?
Or does a case have multiple subjects because thats what the result you need seems to suggest?
Hello, a case always has a single subject.
What I am looking for is how many subject have 1, 2, 3 etc cases as per last table.
I can do it with a Group by but I have a problem when I try to apply filters using the date field...