The calculating of results across the normal data and stacked data sets are supported in StoryTeller and in the Cross table tool 2.0. Below you find some examples of the logic when calculating result across the data sets, these examples are based on the example data below.


Example 1:  Variable in normal file filtered by variable in stacked file

  • Selected Question: Awareness Top of mind, Answer 2
  • Selected Filter: Statement 1, answer 5
  • Result calculation: 2/3=66.67%¬†

The green cells in the stacked data fulfil the filtering criteria so Respondent Id 1, 2 and 3 are used in result calculation.




Example 2: Variable from normal file filtered by variables in stacked file and normal file

  • Selected Question: Awareness Top of Mind, Answer 2
  • Selected Filter: Statement 1, Answer 5 and Gender, Answer 1
  • Result calculation: 1/2=50%

The green cells in the stacked data fulfil the filtering criteria but only respondent id 1 and 3 fulfils theGender filter in the normal file so only Respondent Id 1 and 2 are used in result calculation.


 

Example 3: Variable from stacked file filtered by variable in normal file

  • Selected Question: Statement 1, Answer 4
  • Selected Filter: Gender, answer 1
  • Result calculation: 3/9=33.33%

The green cells in the normal data fulfil the filtering criteria so Respondent Id 1, 3 and 4 are used in result calculation.



Example 4: Variable from stacked file filtered by variables in normal and stacked file

  • Selected Question: Statement 1, Answer 4
  • Selected Filter: Gender, Answer 1 and Statement 2, Answer 5
  • Respondents fulfilling the filter, these which will be included in the calculation of the result: 3and 4
  • Result calculation: 1/3=33.33%

The green cells in the normal data fulfil the filtering criteria and out of those are only the green cells in the Stacked file fulfilling the filter so only these 3 respondents are used in result calculation.



Filtering exception when having multiple stacked data sources


In case of having more than 1 stacked data source like in the example below filtering across the stacked data sets is not supported when the selected question comes from any of the stacked data sets.


E.g. if the selected question comes from the third file in the image below it is not supported to use filter variables from both the stacked files simultaneously.


If the selected question comes from the normal file you can apply filters from both the stacked files simultaneously.