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
Use CONTAINS() in your filtering.
I don't know why, but it counts 38 with any text, something wrong
COUNT(FILTER("base", CONTAINS([done by] , "@"))
Even with "superuser@"?
even with "superuser" or "powerbot" everytime 38 but actully its 64 for superuser and 0 for powerbot
I did bot for changes and return values, it works, but I think this is not the correct way
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |