hello-
i have created a lab safety inspection app, and i am attempting to create a view that allows our safety inspectors to see how many individual unresolved observations there are in each lab.
as of right now, when i click on any given lab, it shows -ALL- open/unresolved observations, rather than the ones pertaining to that individual lab.
so far the expression is:
(COUNT(SELECT(Observations[Observation ID], (NOT([Resolved?]=TRUE))))),
my google sheet also has a [Lab] column.
I am guessing this is rather easy, do i just need some kind of โandโ expression tacked on to the one above?
-Thanks!
Andrew
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |