cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Issue 
In Survey Data you might have 10th or even 100ds of parameters per questionnaire, Sisense suggest transposing all the parameter into one column (See article). Once you do that you might run into an issue filtering questionnaires that answered A AND B, in a simple filter you will actually get A OR B.
Data sample
How it looks on the dashboard when you filter 1 AND 3

     
Solution
Step 1 - If dimension doesn't exist, Create two new Distinct dimension table one for the ID and the other for the indicator, and connect them to the matching field

Step 2 - Create a value with an IF statement "flagging" any values that has the same amount of indicators as we selected (In our case we selected 2 Indicators)

Step 3 - Create a filter based on that value and select the flag we created (You can also Star Favorite it to use in different dashboards).

Result
We see only the ID that has all of the selected indicators (In our case ID 1)

Version history
Last update:
‎03-02-2023 09:42 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy