How can I create a new variable based on scoring categories? | XM Community
Skip to main content

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?

Be the first to reply!

Leave a Reply