Forum Discussion
Dynamic text that will show different cases depends on values
Anonymous
Apologies for the late reply, I got distracted with some other business. Here is the sample file with he solution https://www.dropbox.com/t/x57u2iHQmfZyrYPvActually this need some improvement. It need to be more dynamic by interchanging between male and female (whoever scores more) and perhaps concatenate the lower scored answered and/or providing counts of higher and lower answers in order to have accurate presentation of the results.
As I can't share real names and values, I'm trying to make similar:
a table like:
| person_id | _question | _answer | _gender | |
| 1 . | some_quest? . | 1st_type . | male | |
| 2 . | some_quest? . | 1st_type . | male | |
| 3 . | some_quest? . | 2st_type . | female | |
| 4 . | some_quest? . | 3st_type . | male | |
| 5 . | some_quest? . | 3st_type . | female | |
| 6 . | some_quest? . | 1st_type . | female | |
| 7 . | some_quest? | 1st_type . | female | |
| 8 . | some_quest? . | 2st_type . | female | |
| 9 . | some_quest? . | 2st_type . | female |
Then I calculate simple percentage for each answer, when I divede number of people who answered each type of answer and devide by all people who answered this question by any answer, for example in this table the calculation for 1st_type of answer will be 4/9.
This percentage I report as bar chart where x-axis is calculated value, y-axis is type of answer and divide it by gender legend.
Community ChampionAnonymous
Apologies for the late reply, I got distracted with some other business. Here is the sample file with he solution https://www.dropbox.com/t/x57u2iHQmfZyrYPv
Actually this need some improvement. It need to be more dynamic by interchanging between male and female (whoever scores more) and perhaps concatenate the lower scored answered and/or providing counts of higher and lower answers in order to have accurate presentation of the results.