I have the table above and want to count the unique people who have completed a task. My formula must be wrong b/c I’m getting 3 (John, John, Andy) instead of 2 (John and Andy).
My formula is:
Can you try
Test. Filter (completedTask=yes).name.unique().count()
Let me know if it works!
That worked, thanks!
So if I’m understanding the Test.filter returns a filtered table that it was then counting unique rows of (I would think the answer would still be 2), but with your addition, I’m then calling just the Name column of the filtered table and counting the unique values from that, which makes sense. thanks!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.