Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Expand all | Collapse all

How to use the EITHER OR logic to filter multiple columns

  • 1.  How to use the EITHER OR logic to filter multiple columns

    Posted Tue June 09, 2020 10:58 AM

    Hello, I know it is possible to filter one column in a report table using the EITHER OR logic "||" to evaluate more than one value at the same time. 

     

    Is it possible to filter a report table and evaluate multiple columns at the same time with the EITHER OR logic?  Something like - column A = BLANK or column B = BLANK or column C = BLANK

     

    Thank you


    #Platform


  • 2.  Re: How to use the EITHER OR logic to filter multiple columns

    Posted Tue June 09, 2020 01:33 PM

    I have not found anyway to do what you are asking from a report filter perspective.  You can create another hidden or shown report column that concatenates columns together and then filter on that new column perhaps.  Alternatively, you can include the logic as a flag=yes or no in your table structures and use the flag as a filter in the report. 

     

    A side note:  I've added some longer concatenation logic into my tables for more precise groupings in reports since you can only groupby a select number of columns in a report.  This has been working well for me and improves the performance of the report.


    #Platform