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?

Answers

  • @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'

     

     

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

     

     

  • 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

  • @hyudolee 

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

  • @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?

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