search box with expression

[#1]

I would like to put this expression in a search box, but it didn't work.

It returns me the date that my truck will come back. And I need to filter my table through the date that this expression gives me.

In a graph it work very well but I need it in the search box.

=Floor((max(aggr(max(Distancia),Veículo,[Código Instrução Filial]))/550)+max(aggr(max([Previsão Entrega]),Veículo,[Código Instrução Filial])))

When I put it in a List for exemp... it returns me the aggr of all dates, If I put a dimension in a list with this expression, works, but I can't filter by the expression.

Thank you

[kaushiknsolanki]

Hi,

     instead you can create a button to execute this expression and then select the resulted value from date field.

     All you need to do for this is, Add action on button click to select the value from field.

     and then in search string area you can put this expression.

Regards,

Kaushik Solanki

[#3]

The last column on the table is the expression working. Who will see it need to know how many trucks will come back 'today' for example. But there's a lot of trucks that will arrive today, in many different hours, so I need to put this expression to select just one day and see what are the trucks that will arrive 'today' or 'tomorrow'

[#4]

hi,

Will you please upload the sample application

[#5]

The file is very big.

Try it.