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 |
---|---|
25 | |
25 | |
25 | |
23 | |
16 |