0

Create an OR filter

Hello,

I have a discover as below

I want to create a filter that says either the first employee_flg = Y (table 1) or the second employee_flg (table 2) = Y

Is it possible to do this in an discover ?

Thanks

Mad

4 replies

null
    • imbarmarinescubar_pyram
    • 2 mths ago
    • Reported - view

    Hi  ,

    You can create a calculation and then filter by it.
    For example, you can create a custom column (formulation app -> column) and then add it as a slicer to the discovery.
    Would looks something like:

    [table1].[employee_flg] = "Y" || [table2].[employee_flag] = "Y"

    You can find more details on how to create a custom column in the help site:
    https://help.pyramidanalytics.com/Content/Root/MainClient/apps/Formulate/Custom%20Columns/Custom_Columns_Overview.htm

    • Mad_Amruthur
    • 2 mths ago
    • Reported - view

    Hello,

    Thanks for the reply

    I thought custom columns could be created only involving 1 table

    In this case, I have these columns in 2 different tables

    I will read through the help to see if I can build a custom column across 2 tables

    Thanks

    Mad

    • Mad_Amruthur
    • 2 mths ago
    • Reported - view

    Ahh I see the difference between a custom column and a virtual calculated column (this is what I have been using extensively)

    Let me try creating a custom column via formulate and then use that filter

    Thanks again

    Mad

      • Mad_Amruthur
      • 2 mths ago
      • Reported - view

      That worked well and thanks for the tip

      I did not realize there were 2 different things between Virtual column and custom column(via formulate)

      I used the 2nd option and it worked well

      Thanks

      Mad

Login to reply

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 4Replies
  • 35Views
  • 2 Following