cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
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:

 

Community_Admin_7-1634627102566.png

   

Community_Admin_8-1634627102575.png

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

 

Community_Admin_9-1634627102548.png

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)

 

Community_Admin_10-1634627102561.png

Step 3 - Create a filter based on that value and select the flag we created (You can also Star Favorite

Community_Admin_11-1634627102577.png

it to use in different dashboards).

 

Community_Admin_12-1634627102608.png

Result

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

Community_Admin_13-1634627102592.png

 

Version history
Last update:
‎10-19-2021 12:06 AM
Updated by:
Contributors
Community Toolbox

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

Need additional support?:

Community Support Request