How to filter range of measure value for specific dimension

user01073
user01073
in Magic ETL

Hello,

I need to ignore some specific range of measure data for some specific dimension value. Please help.

 

Eg :

eg.PNG

 

Yellow lines to be ignored.

when product name = computer or laptop then amount is not equal to between 100 to -100

 

Please advice.

 

Thanks

Bikash

Best Answers

  • Valiant
    Valiant Coach
    Answer ✓

    If you're wanting to remove rows where the product is computer or laptop and the value is between that range you could do something like this:

     

    CASE WHEN `Product Name`  IN ('Computer','Laptop) AND `Amount` >= -100 AND `Amount` <= 100 THEN 1 ELSE 0 END

    If you use that beastmode as your filter value and set it = to 0 then you would only be looking at "non-yellow" rows.

     

    Let me know if this isn't what you were trying to accomplish.

     

    Sincerely,

    ValiantSpur

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • user01073
    user01073
    Answer ✓

    Thank you for the prompt response. This worked. ?

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    If you're wanting to remove rows where the product is computer or laptop and the value is between that range you could do something like this:

     

    CASE WHEN `Product Name`  IN ('Computer','Laptop) AND `Amount` >= -100 AND `Amount` <= 100 THEN 1 ELSE 0 END

    If you use that beastmode as your filter value and set it = to 0 then you would only be looking at "non-yellow" rows.

     

    Let me know if this isn't what you were trying to accomplish.

     

    Sincerely,

    ValiantSpur

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • user01073
    user01073
    Answer ✓

    Thank you for the prompt response. This worked. ?

Categories