Filter by Property

hyudolee

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.

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".

Do you have any idea?

Accepted answers

All comments

KirillKuznetsov

@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)

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

Hi, @KirillKuznetsov !

I tried your suggestion, but I couldn't.

Module

Filter

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

Burmeister

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

KirillKuznetsov

@hyudolee

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

hyudolee

@KirillKuznetsov

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

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

What is this difference?

KirillKuznetsov

@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.

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…