Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings community,
I am working on getting a table to show the students that are incompleted on the bases of:
Count(DISTINCT {$< [Transcript Status Description] = {'Confirmed', 'In-Progress'}>} [Learner TID])
Currently that is in my measure column.
I am having a hard time getting this set modifier to count null values in the same column [Transcript Status Description].
I have attempted to create an if statement into a variable, but it doesn't seem to play nicely with the table as it does with my KPI
any suggestions??
Can you add [Transcript Status Description] to this table and see what happens?
That is strange... are you sure you have not made any selections? Difficult to say what the issue might be because the expression should work in KPI and table.
I have gotten some progess
I think I know why its doing this.. I have a concat field (student).
add [Learner TID] as a dimension.... It seems you are adding these as fields may be
yup totally did the trick!
Thank you again!!