Creating a complex filter to allow dashboard linked filters
It is difficult to explain what we would like to do, but I will try:
Just imagine that we have two different reports with two views and dimensions:
Field CHOICES (N:M RELATIONSHIP) with possible values 'CH1','CH2','CH3'
FILTER1: Applying a simple choice filter in the field CHOICES
TABLE2 (in this case the previous N:M relationship was transformed in 3 boolean fields)
Field CH1 with possible values Yes/No
Field CH2 with possible values Yes/No
Field CH3 with possible values Yes/No
FILTER2. Filter by CH1 or CH2 or CH3??? We would like to simulate FILTER1.
That's is because we would like to join both reports in a dashboard. In order to do it in a nice way, we would like to join both filters but we don't know whether it is possible or not to create a FILTER2 which simulates the same working of FILTER1 or vice versa, even with Freehand SQL.
Many thanks for you help.