Reduced bases / Calculation based on content of different field
I'm thinking about a solution for a quite common type of information: Shares on reduced bases, most common is here "Based on users".
For example "Ad Image for those who use the brand".
So I would have Brands as answers to "What Brands do you use?" in Field "Brand_Usage" for each respondent.
And I would have the brands for each respondent for the image question (To keep it very simple :"What brands do you like?" ) from all users who know the Brand in the field "Brand_Image"
If I take Brand_Image as Dimension and something like "count(resp) /count(total resp) as expression, I get the share of People who like the brand for each brand.
What is necessary to calculate this share based on the Users of each brand? So I have a different base of respondents for each brand, depending on the answers to brand usage.
It is obviously sufficient just to click on the users of Brand A and see what the outcome is for the image of Brand A in order to get this information. But you would have to do this for each brand separately and this is not quite comfortable. We are used to get this information in one diagram, indicating that it is based on Users of the respective brand only.
