Help with an expression

[abjackso]

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

[Steve]

What is the expression for? A slice row filter?

[abjackso]

yes, I believe so

[Steve]

I would think all you’d need is:

NOT([Resolved?])

[abjackso]

would it help if i linked anything?

[abjackso]

I have that on a view to show all “open observations”, but I was hoping to do a count of them by lab:

If you can see the image, there are 38 open observations overall, and its showing up that way for the “lab” view too…this is where I’d like to have it read open observations by lab too.

I apologize if my image doesn’t load…I can see it on the right side of my screen as I type this.

[Steve]

So this isn’t a slice row filter.

abjackso:

I am guessing this is rather easy, do i just need some kind of ‘and’ expression tacked on to the one above?

help.appsheet.com

AND()

Are all true?