Button to filter field values less than another field

[GMonty]

Hello

I'm creating a dashboard and I want to include a button than when pressed filters to all the weeks where the 'cost' field is less than a corresponding 'target' field.

My table looks something like this:

Week | Cost | Target

1 | £20 | £25

2 | £50 | £70

3 | £100 | £55

4 | £95 | £2

So the button would filter to weeks 3 and 4

Any Ideas?

Thanks

[Nis_Alsheikh · Accepted solution]

Hello,

You can create a helper field with an IF condition to identify the weeks where Cost < Target. For example:

IF(Cost < Target, 'Yes', 'No') as IS_COST_LESS

Then you can use this field in your app to create a filter button that selects only the “Yes” values. You can add it either in the load script or directly in the design, depending on your setup.

Hope this helped.

[GMonty]

Amazing, thank you, this seems so obvious now!