Button filter

[Anonymous]

I have a gauge field, which displays a count for a below table. (Expression: =count(if(NEED_BY_DATE < date(today()),0)))

Can I have it so that if I click the gauge output (like a button)  it will filter the below table to just show that results for that count?

[YoussefBelloum]

Hi,

you can set an action to set a value (your expression value) into a variable, and use that variable in a set analysis on the expression of the table below.

[Anonymous]

Would you be able to provide an example of how to do this?

[YoussefBelloum]

Give me a set of data and I'll try to give you an example

[YoussefBelloum]

or if you can't, just tell me and I'll try to create it for you

[Anonymous]

Example Attached

[YoussefBelloum]

So using the image below, what are you trying to select and what is your expected output ?

[Anonymous]

I am trying to select the overdue '4' so that it will only return the 4 red dates in the table. I would like the same for the orders within lead time, when you select the '6' the table will only show those results in the table.

[YoussefBelloum · Accepted solution]

Please find attached

[Anonymous]

Is it only the actions in the gauge box all you changed? If so, this is not working on mine