I have [done by] row in "base" its content date and user name like "12/07/2022 13:54:36 superuser@gmail.com"
I need to count how many times cells in [done by] contain the text "superuser" in the virtual column, tried like this but it doesn't work
COUNT(FILTER("base", [done by] = "superuser"))
Thank you
User | Count |
---|---|
16 | |
14 | |
8 | |
7 | |
4 |