Filter Data on a Straight Table

Frquiroga1995 — Tue, 04 May 2021 20:03:01 GMT

Hi ! This is an example of my databse (days is a expression which calculates the difference between Date1 and Date2).

I would like a Straight Table object in the front, that only shows the records where estado_principal = Pendiente.

Thanks !

Re: Filter Data on a Straight Table

rwunderlich — Tue, 04 May 2021 21:02:16 GMT

The set is:

{<estado_principal={'Pendiente'}>}

You can use it in the days expression, or make estado_principal column like:

=Aggr(Only({<estado_principal={'Pendiente'}>} estado_principal), estado_principal)

-Rob