How can I filter a grid on a UX page that does not have that dimension

sagarkpr · 2023-02-01T21:23:40+00:00

There was an error rendering this rich post.

Use case

Module - Emp Details

List Used - Employee

Line items - State (List), Emp Start Date (Date)

On my UX Page, I would like to create a State filter that allows me to filter only those employees that belong to that site.

Since Emp Details doesnt have State as a dimension, its not available as page selector.

Accepted answers

All comments

ryan_kohn

There is a How To article on leveraging the Current User Filter technique for building the type of filter you are interested in. The article was written for the Classic UI, but the same concepts will work on a UX page.

Alternatively, you can just leverage the native filtering available on a grid card to allow people to filter by that specific line item, as long as the line item is visible on the grid.

sagarkpr

Thanks @ryan_kohn, this helps. I was just thinking filtering from page selector perspective but we can always filter on Grid. I will try that

alexpavel

@sagarkpr : isn't enough for users to use native filtering directly on the published grid?

The advantage is that the user could select multiple States to filter.

If you really want to have Page selector of the State you could to create an additional module with Lists Emplyee and State with exactly the sale line-items and with "Apply To" only list Employee in order not to duplicate too much cells.

You can create a new line-item "Filter State" with formula like item(State) = State and publish in NUX this additional module with the NUX filter "Filter State" = TRUE.... but not sure if it's worthy all the effort :).

Hope it helps

Alex

sagarkpr

Thanks @alexpavel That's exactly I got it working before I posted the question. I didnt like that I had to create additional module and line items to get it. So I posted the question.

I think the inherit filter on the grid looks good. Only downside, that filter cant be synced to other visuals on the page. if we have 4 grids and chart. User will have to apply filter on all 4. Page selector can be synched and has that advantage

alexpavel

@sagarkpr : in that case you could follow the Current user filter approach as @ryan_kohn mentioned.

you can publish the State line-item from the user filter module as "Field" card to have similarity with "Page" selectors and apply to all cards and page selectors the current user State filter.

However.. you still need to create the filter modules :).

But, the Current user filters mechanism is automatically refreshing on all cards/grids published.

Duplicating the Employee module with the State list seems that requires less effort :).

Alex

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385