Post

3 followers Follow
0
Avatar

Advanced filter in report

Hello,

I need to filter data using an advanced filter like "3 and 4 and ((1 and 2) or 5)"

The problem is that some rows are duplicated (even appear 4 times) depending which part of the filter bring them.

It looks like if the OR filter adds the rows and doesn't insert an OR condition in the filter as expected.

Is there a way to avoid duplicated rows ?

Thanks

 

Fabienne Gandon Answered

Please sign in to leave a comment.

4 comments

0
Avatar

What type of report is it? Can you post a screenshot of how the report is configured?

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

Hi Josh,

Here is a screenshot of the filters I 'd like to use. I had no duplicated row since the filterwas only build with criteria 1 to 4 without advanced logic (1 and 2 and 3 and 4).

Thanks,

Fabienne Gandon 0 votes
Comment actions Permalink
0
Avatar

I would need to see the rest of the report configuration as well, not just the filter window.

Can you also try changing the criteria to:

(1 AND 2 AND 3 AND 4) OR (3 AND 4 AND 5)

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

Hi Josh,

I tested the option you suggested but still have the same results with dupliacted rows (4 times each).

Thez name of the report is "Envoi formulaires NPS déploiement". Can you access it ?

Fabienne Gandon 0 votes
Comment actions Permalink