Filter by Property

hyudolee
Occasional Contributor

Filter by Property

Hi, I have a question about filter function.

 

I have two tables. 

First one shows amount by Location-Product List.

The Second shows amount by Product List. 

Location-Product List has Product List as Properties.

hyudolee_1-1641881816272.pnghyudolee_2-1641881838023.png

 

I want to display these tables in one UX Dashboard.

Then I want to filter the second table(Product) by First Table(Location-Product).

This means, When I watch the amount of "X-A" Location-Product,

I want to watch the amount of "A".

hyudolee_0-1641881609375.png

 

Do you have any idea?

6 REPLIES 6
KirillKuznetsov
Certified Master Anaplanner

Re: Filter by Property

@hyudolee 

You would need a boolean filter module for this. The dimensions would be Location-Product list and Product List.

So for selected Location-Product you could see only applicable product. To apply this filter use global selector and set filter from it (instead of Oct 21 - should be Product list of course)

KirillKuznetsov_0-1641886061342.png

 

To automatically match the boolean you can identify the products by part of name of the Location-Product list items using formula RIGHT(<LOC_PROD NAME>, 1) and then apply FINDITEM to Product-list-formatted line item. After this you will have to compare ITEM(Product list) = 'Product item in Location-Product list'

 

 

hyudolee
Occasional Contributor

Re: Filter by Property

Hi, @KirillKuznetsov !

 

I tried your suggestion, but I couldn't.

 

Module

hyudolee_0-1641888204670.png

hyudolee_2-1641888255682.png

 

 

UX

hyudolee_1-1641888240906.png

Filter

hyudolee_3-1641888305780.png

 

The Filter context doesn't selected automatically, I have to chose any one.

 

 

KirillKuznetsov
Certified Master Anaplanner

Re: Filter by Property

@hyudolee 

Add Location-Product dimension to Product amount module. Then filter should work.

hyudolee
Occasional Contributor

Re: Filter by Property

@KirillKuznetsov 

I add the Location-Product dimension but I couldn't.

hyudolee_0-1641892285447.png

 

hyudolee_1-1641892314085.png

 

But I could filter it when I set the Product as Rows.

hyudolee_2-1641892505187.png

 

What is this difference?

KirillKuznetsov
Certified Master Anaplanner

Re: Filter by Property

@hyudolee 

Yes, pivot to rows helped because this is how filter works with dynamic selection of the mapped items.

Seems like it's not allowing you to filter one selector based on selected elements in another one.

But the workaround you applied works.

Burmeister
New Contributor

Re: Filter by Property

The filter CSS property applies graphical effects like blur or color shift to an element. Filters are commonly used to adjust the rendering of images, backgrounds, and borders. Included in the CSS standard are several functions that achieve predefined effects.

 

walgreenslistens