Hi all -
I just want to know why the distinct count in beast mode is not working..
in the screenshot, I have a count distinct on the resource names, but there are still duplicates appearing and being recognized as distinct.
I am using this formula
COUNT(DISTINCT CONCAT(trim(`Test Taker: Resource Name`)))
any thoughts?