Possible Filter?

[madelinehermes]

I need to create either a specific filter or parameter/field, I'm not sure which would apply. I have a "Service Area Code" dimension as well as a "Segment Type" dimension. Is it possible to create something that removes the "Service Area Code" if it's equal to "NATL", UNLESS the "Segment Type" is equal to "OTR"?

[阿泰]

I think you can break down the filter process as follows:

• Create a new custome column, apply the SQL below:
  CASE
  WHEN "Segment Type" = "OTR" THEN "Service Area Code"
  ELSE "NATL"
  END

• Create a filter in your report and set the condition to filter data.
  Exclude condition: Custom field ≠ "NATL"