Forum Discussion

Maxfran's avatar
Maxfran
Icon for Helper I rankHelper I
6 years ago
Solved

Or Condition on page filter

Hi,    My problem: I want my report to be filtered by "FD1 = X" OR by "FD2 = X", FD1 and FD2 being 2 different variables. The report has to show data from individuals having X value either in the...
Need Help
  • Maxfran's avatar
    Maxfran
    6 years ago

    That makes sense. Yet, I was hoping something that needed fewer manipulations (adding each filter individually is a bit repetitive) but I guess I can do it. 

    The other solution I found is to create a new column by concatenating FD1 and FD2. Then I added an advanced filter on the page and that requires the concatenated variable to contains "X". 

     

Maxfran's avatar
Maxfran
Icon for Helper I rankHelper I
6 years ago

Thanks for this precision. 

 

It 707 contains 70, but not 70_ with an underscore implemented during the concatenation. 

So, if I filter to have only "70_", it will be fine. 

 

Actually, my data are text but I had the same issue that you presented with numbers.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago

Maxfran of course, sorry I didn't read carefully enough. Genius solution.