Identifying if a list item is a property on a separate list

CommunityMember83188
CommunityMember83188
in Modeling

Hi,

I have two numbered lists, City and Product.

Product has City as a property.

All Products have a City as a property, and multiple Products can have the same City as a property, but not all Cities may be linked with a Product.

In a module with City list as a dimension, how could I identify if a City has been linked with a Product (it doesn't matter if it's one or many)?

Thanks,

Tagged:

Best Answer

  • kavinkumar
    kavinkumar
    Answer ✓

    HI Ceri,

     

    You can bring it in this way. Please follow the steps below.

     

    Step 1: In your Product list add a number formatted line item and make it as 1 in the forumula

     

    Identifying if a list item is a property on a separate list.PNG

     

     

    Step 2 : In your module just do refer the above property(Count) by putting SUM:Country list property and you will get the count as no.of products and if it is 0 then that City is not linked to any Products. In my example "Chennai" city is not linked to any of the products.

    Identifying if a list item is a property on a separate list 1.PNG

    Hope this confirms your requirement. Let me know if you have any concerns.

     

    Thanks,

    Kavin.

     

Comments

  • rob_marshall
    rob_marshall

    The above will work, but please don't put those line items in a list, put them in a Module as this will help performance, will help with the general understanding and maintaining of the model, as well as show up on the Model Map (list properties do not show up on the model map).

     

    Thanks,

     

    Rob

Categories