Filter (button?) that applies set expression?

RoyBatty — Tue, 02 Apr 2024 21:35:50 GMT

Hi,

On the sheet we have a simple user table that only has dimensions: Name, Email, User ID ...

There is also a KPI that has the following measure:

Count({<[Standard Activity Period]={'Y'}, [Activity]={'Payment'}>} distinct [user_id])

Then we used the set expression that was used for the KPI to show me only those specific users in the users table. It looks like this:

=Aggr(
Only({<[Standard Activity Period]={'Y'}, [Activity]={'Payment'}>} distinct [user_id]), 
[user_id]
)

We specified that for the "user_id" column (dimension) of the users table and it works, everything is good, it only shows those specific users. However, is it possible to make a special filter/button, something that is "toggleable": when we click on it to apply that set expression, when we click again to remove it?

We tried with the "Button" element, with different types of actions to apply that set expression (as "value"), but nothing worked.

Re: Filter (button?) that applies set expression?

marcus_sommer — Wed, 03 Apr 2024 13:01:28 GMT

I suggest just to use the normal usability and providing the period/activities as selections and then the user selects the wanted views. It's not only simpler in the development/maintaining else also in the usability if no button/action magic is included.

topic Re: Filter (button?) that applies set expression? in App Development

Filter (button?) that applies set expression?

Re: Filter (button?) that applies set expression?