Help with an expression

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

0 6 97
6 REPLIES 6
Top Labels in this Space