Button, acting as a bookmark

[mamaewapolya]

Hi everyone,

I am struggling to create a button, which will limit the selection to the conditions I want. My dashboard consists of a table with the orders.

What I was initially trying to do is to limit the selection, applying the set expression to a column:

=Aggr(Only({<Direction={'Export'},ShipmentType={'Consolidated','FullContainer','LessthanContainer'},ETD={"<=$(=Today()+7)"}>} OrderNo), OrderNo)

But this did not work. I was also trying to create a variable with the same condition and attached it to a button, but it did not work either.
Could you please let me know if there is a solution to filer the data in some may, that meets my request?

Thank you,

Polly

[Taoufiq_Zarra]

@mamaewapolya  can you share a sample data and the expected output

[mamaewapolya · Accepted solution]

Hi @Taoufiq_Zarra , I was able to solve the problem by using variables 🙂

Thank you!

Polly