I’m putting together a work styles assessment that has scoring categories set up. There are four categories (Above, Below, Right, Left), with each category having a score range from 0-9.
I was able to set up embedded fields based on these categories. At the end of the assessment, I have display logic programmed to show what Workstyle the respondent falls under, based on the scores in these four categories. There are four workstyles in total that align to a quadrant.
Here is an example of the logic:
Workstyle #1:
- If Above is equal to or above 5
- AND if Right is equal to or above 5
- AND if Below is less than 5
- AND if Left is less than 5
Workstyle #2:
- If Below is equal to or above 5
- AND if Left is equal to or above 5
- AND if Above is less than 5
- AND if Right is less than 5
And so on….
In terms of reporting, I want to be able to export the data and have a new field created with the output of one of the four workstyles assigned to each person, but I’m getting stuck. I tried to use the formula option, but the embedded fields don’t show up as a field, just the items. Bucketing isn’t quite working either.
Is this possible to set up?